Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version

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