• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 699
  • Last Modified:

need to know if postgres is installed in 32 or 64 bit

i installed the SUNWpostgr packages available off sun's site, but do now know whether these are 32 or bit bit. how can i know?

thanks
0
ixarissysadmin
Asked:
ixarissysadmin
  • 3
1 Solution
 
ivanovnCommented:
I believe if you do SELECT version() the result will show you what binaries you have.
0
 
ixarissysadminAuthor Commented:
i did:
createdb test
psql test
test=# select version()

but nothing was returned. i simply get the prompt again. no output
0
 
ixarissysadminAuthor Commented:
worked now by adding a ; but i still do not get 32/64 bit

postgres=# select version()
postgres-# ;
                                           version
----------------------------------------------------------------------------------------------
 PostgreSQL 8.1.4 on i386-pc-solaris2.10, compiled by /ws/on10-tools/SUNWspro/SOS8/bin/cc -Xa
(1 row)

postgres=#
0
 
ixarissysadminAuthor Commented:
all you need to do is to run the cmd 'file' on the <postgres>/bin/postgres binary!
0
 
Computer101Commented:
Closed, 500 points refunded.
Computer101
EE Admin
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now