Re: how to recover corrupt data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Adler <adler(at)pobox(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to recover corrupt data
Date: 2004-02-17 23:45:03
Message-ID: 18918.1077061503@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-02-17 23:59:51 Re: large objects missing
Previous Message Benjamin Wragg 2004-02-17 22:28:24 Re: Restoring pg_dump's made using COPY commands