Re: invalid page header

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Guerin <guerin(at)rentec(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: invalid page header
Date: 2004-06-09 16:40:05
Message-ID: 26204.1086799205@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Michael Guerin <guerin(at)rentec(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Lynna Landstreet 2004-06-09 18:11:55 Character encoding in database dumps
Previous Message Michael Guerin 2004-06-09 16:32:26 Re: invalid page header