Question about PG_CONTROL_VERSION 1
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
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
On 14-04-2021 17:41, Tom Lane wrote:
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
Hello,
thank you. I resolve the issue and get my data back successful. I create
a new database and check the number that new database is created and I
replace only datafiles from old directory to new one. In few years back
I was trying to start similar topic without success, when you have the
data but indexes and/or transaction log is corrupt / broken, how to get
the data back without indexes and transactions log. I export my old
data. Thanks again.
Regards,
HS