Re: Recovering database after disk crash

During the initial ill-educated messing around I had set the
zero_damaged_pages to yes, but I'm guessing that the end result is the
same... Ill try it with the fresh copy of [the corrupt] data

What kind of a database can't deal with a bit of random values
injected into its sytem files anyways? :)



On 5/12/08, Tom Lane <tgl@[EMAIL PROTECTED]
> wrote:
> "Vic Simkus" <vic.simkus@[EMAIL PROTECTED]
> 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
>


-- 
Men never do evil so completely and cheerfully as when they do it from
religious conviction.

-Blaise Pascal

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general