ixarissysadmin
asked on
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
thanks
I believe if you do SELECT version() the result will show you what binaries you have.
ASKER
i did:
createdb test
psql test
test=# select version()
but nothing was returned. i simply get the prompt again. no output
createdb test
psql test
test=# select version()
but nothing was returned. i simply get the prompt again. no output
ASKER
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/SO S8/bin/cc -Xa
(1 row)
postgres=#
postgres=# select version()
postgres-# ;
version
--------------------------
PostgreSQL 8.1.4 on i386-pc-solaris2.10, compiled by /ws/on10-tools/SUNWspro/SO
(1 row)
postgres=#
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Closed, 500 points refunded.
Computer101
EE Admin
Computer101
EE Admin