Re: fatal error - different CATALOG_VERSION_NO - Mailing list pgsql-general

From Tom Lane
Subject Re: fatal error - different CATALOG_VERSION_NO
Date
Msg-id 26101.979489878@sss.pgh.pa.us
Whole thread Raw
In response to Re: fatal error - different CATALOG_VERSION_NO  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
>> $ Waiting for postmaster to start up...FATAL 2:  database was initialized
>> with CATALOG_VERSION_NO
>> 200012280,
>> but the backend was compiled with CATALOG_VERSION_NO 200101061.
>> looks like you need to initdb.

>> do i have to follow the upgrade procedures?

> Yes

If you're trying to store useful data in a CVS-tip installation,
it's a good idea to pay close attention to the CVS logs, particularly
http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/include/catalog/catversion.h
which will keep you posted on initdb-forcing changes.

Or to be really safe, always do a backup before updating.

            regards, tom lane

pgsql-general by date:

Previous
From: Fred Yankowski
Date:
Subject: to_char(date '2001-04-01', 'dd') results in 31 -- why?
Next
From: Tom Lane
Date:
Subject: Re: to_char(date '2001-04-01', 'dd') results in 31 -- why?