Scott Marlowe wrote: > On Sun, Sep 25, 2011 at 3:26 AM, Raghavendra > <raghavendra.rao@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
