Обсуждение: 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