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@xxxxxxxxxxxxx> wrote: > "Vic Simkus" <vic.simkus@xxxxxxxxx> 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
