Re: Checking database version - Mailing list pgsql-admin

From George Wilk
Subject Re: Checking database version
Date
Msg-id 02c801c7d064$dbe8e9d0$1f7ca8c0@ellacoya.com
Whole thread Raw
In response to Re: Checking database version  (Richard Broersma Jr <rabroersma@yahoo.com>)
List 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@yahoo.com]
Sent: Friday, July 27, 2007 11:19 AM
To: George Wilk; pgsql-admin@postgresql.org
Cc: 'Gez Saunders'
Subject: Re: [ADMIN] Checking database version


--- George Wilk <gwilk@ellacoya.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.



pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Checking database version
Next
From: "Tena Sakai"
Date:
Subject: my postgres is dead. need help!