Re: invalid page header

Michael Guerin <guerin@rentec.com> writes:
> Tom Lane wrote:
>>> "Dumping and reloading the table that owns this toast table would be a safer route; it would at
>>> least make it real clear what damage you'd suffered."

> I tried using pg_dump and copy, but both get errors and fail.  Is there
> another way that I should try to export the data?

That's about what I expected would happen.  What you're now down to is
having to identify and delete the specific rows that suffered damage.
Once you can do a "SELECT *" from the table without error, pg_dump will
work.

> Also, I sent another post recently trying to find out how these things
> happen.  The drives seem to be ok, although I still need to memcheck.
> This is the second corruption in a 4 day span, but I can't find any
> clues to why its happening.

I'd be pretty suspicious about bad RAM if I were you ...

            regards, tom lane