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. +
