Postgres Pro
Downloads
Home   >   mailing lists

Recover from failed files - Mailing list pgsql-general

From Nyamul Hassan
Subject Recover from failed files
Date
Msg-id CAPxE06RTkdde-w+5=Wt5GxnrYmmyQBjpxSctibaYqrqainpRew@mail.gmail.com
Whole thread Raw
Responses Re: Recover from failed files  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Ondrej Ivanič
Date:
Subject: Re: alter view foo set () -- fixed in 9.2 stable, but when will it be released?
Next
From: Chris Angelico
Date:
Subject: Re: alter view foo set () -- fixed in 9.2 stable, but when will it be released?