Re: Question about PG_CONTROL_VERSION 1 - Mailing list pgsql-general

From Tom Lane
Subject Re: Question about PG_CONTROL_VERSION 1
Date
Msg-id 3489436.1618411260@sss.pgh.pa.us
Whole thread Raw
In response to Question about PG_CONTROL_VERSION 1  (Condor <condor@stz-bg.com>)
Responses Re: Question about PG_CONTROL_VERSION 1  (Condor <condor@stz-bg.com>)
List pgsql-general
Condor <condor@stz-bg.com> writes:
> I try restore from old hard drive an database. The system is not 
> working, so I install new server, install postgres 9.0.3 and try to copy 
> postgresql dir to new location but I receive error:

> 2021-04-14 11:47:04.205 UTC [10285] FATAL:  database files are 
> incompatible with server
> 2021-04-14 11:47:04.205 UTC [10285] DETAIL:  The database cluster was 
> initialized with PG_CONTROL_VERSION 1, but the server was compiled with 
> PG_CONTROL_VERSION 903.
> 2021-04-14 11:47:04.205 UTC [10285] HINT:  It looks like you need to 
> initdb.

Yeah, that's corrupt :-(.  Probably if you try pg_controldata you'll
find that pg_control is a complete mess.

            regards, tom lane



pgsql-general by date:

Previous
From: Condor
Date:
Subject: Question about PG_CONTROL_VERSION 1
Next
From: Michael Lewis
Date:
Subject: Re: Timestamp/hstore query?