> > 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