| From: | Nyamul Hassan <nyamul(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Recover from failed files |
| Date: | 2012-11-04 23:28:15 |
| Message-ID: | CAPxE06RTkdde-w+5=Wt5GxnrYmmyQBjpxSctibaYqrqainpRew@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Angelico | 2012-11-04 23:55:12 | Re: alter view foo set () -- fixed in 9.2 stable, but when will it be released? |
| Previous Message | Ondrej Ivanič | 2012-11-04 21:48:23 | Re: alter view foo set () -- fixed in 9.2 stable, but when will it be released? |