From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
---|---|
To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
Cc: | "Wang, Mary Y *EXTERN*" <mary(dot)y(dot)wang(at)boeing(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version |
Date: | 2010-02-26 09:43:56 |
Message-ID: | 4B8797DC.2080706@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)2ndQuadrant(dot)com www.2ndQuadrant.us
From | Date | Subject | |
---|---|---|---|
Next Message | Anton Maksimenkov | 2010-02-26 12:02:30 | ERROR: value out of range: underflow |
Previous Message | John R Pierce | 2010-02-26 09:30:17 | Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version |