Recover from failed files

Поиск
Список
Период
Сортировка
От Nyamul Hassan
Тема Recover from failed files
Дата
Msg-id CAPxE06RTkdde-w+5=Wt5GxnrYmmyQBjpxSctibaYqrqainpRew@mail.gmail.com
обсуждение исходный текст
Ответы Re: Recover from failed files
Список pgsql-general
Hi,

A small office customer of ours is in a bit of fix due to a HDD crash on their PGSQL machine.  Their IT support staff on duty left around a week ago, without notice, and apparently, he was not good at keeping backups.

Upon inspecting the hard drive, we were able to salvage the "data" folder, but when we try to load it into the PGSQL version of the data folder (8.2), the server would not load.  Upon closer inspection, we suspect the culprit to be the file 0015 in pg_clog which is 214kb instead of 256kb size of all other files in the same folder.

Is there any way that we can salvage the data from this data folder?

Thank you in advance for your suggestions.

Regards
HASSAN

В списке pgsql-general по дате отправления: