Re: Corrupted Data? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Corrupted Data?
Date
Msg-id 20040915184510.GE4607@dcc.uchile.cl
Whole thread Raw
In response to Re: Corrupted Data?  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-general
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)


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: disk performance benchmarks
Next
From: Alvaro Herrera
Date:
Subject: Re: division by zero issue