Re: Question about PG_CONTROL_VERSION 1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Condor <condor(at)stz-bg(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Question about PG_CONTROL_VERSION 1
Date: 2021-04-14 14:41:00
Message-ID: 3489436.1618411260@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Condor <condor(at)stz-bg(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Lewis 2021-04-14 18:32:22 Re: Timestamp/hstore query?
Previous Message Condor 2021-04-14 14:28:37 Question about PG_CONTROL_VERSION 1