Question about PG_CONTROL_VERSION 1

From: Condor <condor(at)stz-bg(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Question about PG_CONTROL_VERSION 1
Date: 2021-04-14 14:28:37
Message-ID: 53e38022d2b31fafe44750fac5049d80@stz-bg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

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.

How I can start the database or a way to check which files are used for
database that I need it and copy only them ? Did I have a broken files
(probably) ? Is there a way to copy only needed files or some way to
export the data ?

Thanks,
HS

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-04-14 14:41:00 Re: Question about PG_CONTROL_VERSION 1
Previous Message Tom Lane 2021-04-14 14:26:23 Re: Why is writing JSONB faster than just JSON?