Re: invalid page header - Mailing list pgsql-novice

From Tom Lane
Subject Re: invalid page header
Date
Msg-id 26204.1086799205@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:
> "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."

> Is this b/c the damaged pages would be zero'd out?

Right, which would make vacuum happy, but you'd be missing some data.
(Unless you're fortunate enough that there are no currently-live rows
on the damaged page.)

            regards, tom lane

pgsql-novice by date:

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