Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group