Re: invalid page header - Mailing list pgsql-novice

From Tom Lane
Subject Re: invalid page header
Date
Msg-id 20689.1086790429@sss.pgh.pa.us
Whole thread Raw
In response to invalid page header  (Michael Guerin <guerin@rentec.com>)
Responses Re: invalid page header
List pgsql-novice
Michael Guerin <guerin@rentec.com> writes:
> INFO:  vacuuming "pg_toast.pg_toast_17242"
> ERROR:  invalid page header in block 2003917 of relation "pg_toast_17242"

> Is there a way to fix this error, or do I need to rebuild the table?

zero_damaged_pages would get you past that error, but I'd be worrying
about what data you've lost or are going to lose.  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.

            regards, tom lane

pgsql-novice by date:

Previous
From: Michael Guerin
Date:
Subject: invalid page header
Next
From: Tom Lane
Date:
Subject: Re: invalid page header