Re: how to recover corrupt data - Mailing list pgsql-admin

From Tom Lane
Subject Re: how to recover corrupt data
Date
Msg-id 18918.1077061503@sss.pgh.pa.us
Whole thread Raw
In response to how to recover corrupt data  (Michael Adler <adler@pobox.com>)
List pgsql-admin
Michael Adler <adler@pobox.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

pgsql-admin by date:

Previous
From: "Benjamin Wragg"
Date:
Subject: Re: Restoring pg_dump's made using COPY commands
Next
From: Tom Lane
Date:
Subject: Re: large objects missing