Re: What Version Installed?

There are several answers to this.

If you use a package manager like rpm (e.g., RedHat, SuSE, Mandrake),
try:

tallac$ rpm -q postgresql
postgresql-7.3.4-3.rhl9

Most (all?) binaries take a the standard-ish --version flag, like this:

tallac$ initdb --version
initdb (PostgreSQL) 7.4.1
tallac$ postmaster --version
postmaster (PostgreSQL) 7.4.1

You'll notice that I've got two versions installed, so be careful about
knowing which ones you're actually using. (BTW, I don't usually have two
versions installed and doing so probably isn't a good idea for most
people, but I happened to need 7.3.4's psql client briefly.)

Finally, you can ask the server you're talking to:

tallac$ psql -UPUBLIC -c 'select version()'
version
-------------------------------------------------------------
PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC 2.96

-Reece

--
Reece Hart, Ph.D. rkh(at)gene(dot)com, http://www.gene.com/
Genentech, Inc. 650/225-6133 (voice), -5389 (fax)
Bioinformatics and Protein Engineering
1 DNA Way, MS-93 http://www.in-machina.com/~reece/
South San Francisco, CA 94080-4990 reece(at)in-machina(dot)com, GPG: 0x25EC91A0