Re: Corrpupt Data File

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