On Feb 9, 2010, at 3:28 PM, Erik Jones wrote: > Greetings, > > We've recently had database server crash due to a heavy duty disk failure and upon rebooting we now have a table showing corruption via the "invalid page header in block X" message when querying one table in particular, the rest have all checked out via full table dumps with no errors. > > Here is what we've done so far to try to fix the table and/or recover the good data from it: > > * REINDEX -- no good. > > * Set zero_damaged_pages=on, run query that originally showed the corruption. This reports 3 different blocks with invalid page headers and reports that they are being zero'd out. Unfortunately, subsequently querying the table the same blocks show as corrupt. Well, after running the query twice with zero_damaged_pages=on the first one did go away but the other two remain. > > * Set zero_damaged_pages=on for pg_dump. Same results as above. > > I'm unsure what to do next to get those damaged pages cleared out... Scratch that about the first damaged page going away, after a server restart it popped up again. Erik Jones, Database Administrator Engine Yard Support, Scalability, Reliability 866.518.9273 x 260 Location: US/Pacific IRC: mage2k -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
