Re: Corrupted Data?

On Wed, Sep 15, 2004 at 02:37:13PM -0400, Matthew T. O'Connor wrote:

> However, I then ran into a new problem while trying to dump another
> database.  Now I get this:
>
> dbmail=# SELECT * from messageblks ;
> ERROR:  invalid page header in block 85646 of relation "pg_toast_2353340"
>
> Any ideas on this new issue?

IMO this is FUBAR ... try enabling zero_damaged_pages.  Beware that data
on damaged pages will be lost.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La libertad es como el dinero; el que no la sabe emplear la pierde" (Alvarez)