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@2ndQuadrant.com www.2ndQuadrant.us