Albe Laurenz wrote:
To find out what PostgreSQL stuff you have installed (provided
you installed it as RPM and did not compile it from source),
you can run
rpm -qa | grep postgres
Some other useful tricks to know here; most commands take "--version":
$ initdb --version
initdb (PostgreSQL) 8.3.3
Which can help out figuring out which version is which when you have two
on the server.
If you've managed to connect to a server, you can often find out where
it came from like this:
$ psql -c "select version()"
version
-----------------------------------------------------------------------------------------------------------
PostgreSQL 8.3.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20071124 (Red Hat 4.1.2-42)
And if you have the pg_config utility installed in either location,
running it will tell you all sorts of info about how your install was done.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@xxxxxxxxxxxxxxx www.2ndQuadrant.us
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
