Re: Recovering database after disk crash

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vic Simkus" <vic(dot)simkus(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Recovering database after disk crash
Date: 2008-05-13 00:27:59
Message-ID: 5524.1210638479@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Vic Simkus" <vic(dot)simkus(at)gmail(dot)com> writes:
> If I'm understanding the errors correctly it seems that the corruption
> is in the system catalogs (metadata). The database does not use any
> fancy datatypes. Is there any way for me to rebuild the metadata
> manually? If I can see the leftover metadata and the data minus the
> missing metadata I can probably piece everything together enough to
> get the data out.

Based on the evidence so far, the disk failure has zeroed out multiple,
randomly-chosen pages of your system catalogs. I'd think it very likely
indeed that random pages of your table files got the same favor.
You won't have any way to know what is missing ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vic Simkus 2008-05-13 01:00:28 Re: Recovering database after disk crash
Previous Message Vic Simkus 2008-05-13 00:17:22 Re: Recovering database after disk crash