Re: In which case PG_VERSION file updates ? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: In which case PG_VERSION file updates ?
Date
Msg-id 201110071405.p97E5Bk21242@momjian.us
Whole thread Raw
In response to Re: In which case PG_VERSION file updates ?  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Scott Marlowe wrote:
> On Sun, Sep 25, 2011 at 3:26 AM, Raghavendra
> <raghavendra.rao@enterprisedb.com> wrote:
> > Thanks Adrian Klaver,
> > Provided link gives about the information of what PG_VERSION file, which am
> > aware of:)
> > In my observation, all the object related OID's, _fsm, _vm files under
> > $PGDATA/base/database-oid/ directory will change as per the changes made to
> > the database, whereas PG_VERSION file never changes. Because its the file
> > tells on which version of Binary the Data directory is built upon.
> > So, my question is, Is there any case, where PG_VERSION file updates with
> > any of the utility process or
> > PG_VERSION file never been touched by PG-Instance ?
>
> If you run pg_upgrade I'd expect that to change it.

Yes, PG_VERSION is one of the files that is set via initdb on the new
cluster, and that file is not copied over from the old cluster (only
heap/index user files).

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Can we use sqlcode in functions of plpgsql
Next
From: Cédric Villemain
Date:
Subject: Re: Never-idle autovacuum, and does (auto)vacuuming fill the OS cache ?