Alex Derbes <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html