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