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