Skip site navigation (1) Skip section navigation (2)

Re: Checking database version

From: "George Wilk" <gwilk(at)ellacoya(dot)com>
To: "'Richard Broersma Jr'" <rabroersma(at)yahoo(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Checking database version
Date: 2007-07-27 15:43:20
Message-ID: 02c801c7d064$dbe8e9d0$1f7ca8c0@ellacoya.com (view raw or flat)
Thread:
Lists: pgsql-admin
Yes, it does.  However, in one test case after running dump, restoring, and
upgrading to 8.2 the PG_VERSION was still showing 8.1.  This could have been
a result of us monkeying around, but still I wasn't sure when the PG_VERSION
was being updated, and whether it provided reliable source of versioning
information.

-----Original Message-----
From: Richard Broersma Jr [mailto:rabroersma(at)yahoo(dot)com] 
Sent: Friday, July 27, 2007 11:19 AM
To: George Wilk; pgsql-admin(at)postgresql(dot)org
Cc: 'Gez Saunders'
Subject: Re: [ADMIN] Checking database version


--- George Wilk <gwilk(at)ellacoya(dot)com> wrote:

> Is there a reliable way of verifying version of the database by looking at
> the PGDATA directory?

Does the file "PG_VERSION" not tell what you need?

Regards,
Richard Broersma Jr.



In response to

pgsql-admin by date

Next:From: De Leeuw GuyDate: 2007-07-27 15:50:39
Subject: trigger and pg_fini
Previous:From: Kevin GrittnerDate: 2007-07-27 15:20:16
Subject: Re: Checking database version

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group