Re: Checking database version

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.