Обсуждение: What version am I running?

How can I tell what version of postgres I am running?
I thought I was running the current version, but was
mistaken. If I look in /usr/local/pgsql/data/PG_VERSION
it says 7.3 , on a machine I am sure is 7.3.2 .
thanks

--
Danny Aldham     Providing Certified Internetworking Solutions to Business
www.postino.com  E-Mail, Web Servers, Security, Web Databases, SQL PHP & Perl

You can connect with psql and type

select version();


> How can I tell what version of postgres I am running?
> I thought I was running the current version, but was
> mistaken. If I look in /usr/local/pgsql/data/PG_VERSION
> it says 7.3 , on a machine I am sure is 7.3.2 .
> thanks


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

> > How can I tell what version of postgres I am running?
> > I thought I was running the current version, but was
> > mistaken. If I look in /usr/local/pgsql/data/PG_VERSION
> > it says 7.3 , on a machine I am sure is 7.3.2 .
> > thanks

In all versions, the content of PG_VERSION file would be the latest major
version. For example, if you are using 7.3.2, the PG_VERSION file will
have 7.3 and not 7.3.2. To really check out the version, try 'psql -V'
from os shell prompt or 'select version()' from sql prompt.

regards,
bhuvaneswaran