Recover from failed files

Поиск
Список
Период
Сортировка
От Nyamul Hassan
Тема Recover from failed files
Дата
Msg-id CAPxE06RTkdde-w+5=Wt5GxnrYmmyQBjpxSctibaYqrqainpRew@mail.gmail.com
обсуждение исходный текст
Ответы Re: Recover from failed files  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: Ondrej Ivanič
Дата:
Сообщение: Re: alter view foo set () -- fixed in 9.2 stable, but when will it be released?
Следующее
От: Chris Angelico
Дата:
Сообщение: Re: alter view foo set () -- fixed in 9.2 stable, but when will it be released?