Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BF8C09FB68E for ; Fri, 27 Jul 2007 12:43:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 53932-10 for ; Fri, 27 Jul 2007 12:43:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail02.ellacoya.com (67-135-29-172.dia.static.qwest.net [67.135.29.172]) by postgresql.org (Postfix) with ESMTP id C15949FB30D for ; Fri, 27 Jul 2007 12:43:24 -0300 (ADT) Received: from YZANGXP ([192.168.124.31]) by mail02.ellacoya.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 27 Jul 2007 11:43:23 -0400 From: "George Wilk" To: "'Richard Broersma Jr'" , Subject: Re: Checking database version Date: Fri, 27 Jul 2007 11:43:20 -0400 Message-ID: <02c801c7d064$dbe8e9d0$1f7ca8c0@ellacoya.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 Thread-Index: AcfQYX67kPGWVeFaRm+HJLapP1KlAwAARpeg In-Reply-To: <18690.38256.qm@web31813.mail.mud.yahoo.com> X-OriginalArrivalTime: 27 Jul 2007 15:43:23.0304 (UTC) FILETIME=[DD650280:01C7D064] X-TM-AS-Product-Ver: SMEX-8.0.0.1181-5.000.1021-15324.003 X-TM-AS-Result: No--4.725600-4.000000-31 X-TM-AS-User-Approved-Sender: No X-TM-AS-User-Blocked-Sender: No X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/314 X-Sequence-Number: 26295 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 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.