Re: In which case PG_VERSION file updates ?

Scott Marlowe wrote:
> On Sun, Sep 25, 2011 at 3:26 AM, Raghavendra
> <raghavendra(dot)rao(at)enterprisedb(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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