Re: Corrpupt Data File - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Corrpupt Data File
Date
Msg-id 11655.1077804017@sss.pgh.pa.us
Whole thread Raw
In response to Corrpupt Data File  (Alex Derbes <acd@brillig.org>)
Responses Re: Corrpupt Data File  (Alex Derbes <acd@brillig.org>)
List pgsql-bugs
Alex Derbes <acd@brillig.org> writes:
> deleting the indexes from the table did not help.  Is there a tool or
> method that that I could use to simply skip the bad data and at least
> recover the good blocks?

Just zero out the broken page, eg with dd from /dev/zero.  Note it
might be a good idea to shut down the postmaster while you do so,
else there could be a copy of that page in Postgres shared buffers,
which'd mask your attempted fix.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Alex Derbes
Date:
Subject: Corrpupt Data File
Next
From: Alex Derbes
Date:
Subject: Re: Corrpupt Data File