Michael Adler <adler(at)pobox(dot)com> writes:
> Is there any way to extract this (possibly intact) data?
It looks like you have one corrupted, perhaps partially zeroed, page
in your table. There may be more, but the trace output you show only
has corrupted tuples on one page (11193). You could try replacing that
page with zeroes, which will lose the rows on that page but allow you to
recover the rest of the data. See the archives for discussion of
corruption recovery procedures (searching for references to pg_filedump
will probably lead you to the right threads).
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2004-02-17 23:59:51|
|Subject: Re: large objects missing |
|Previous:||From: Benjamin Wragg||Date: 2004-02-17 22:28:24|
|Subject: Re: Restoring pg_dump's made using COPY commands|