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 14:13:49
Message-ID: 20689.1086790429@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:
> 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Guerin 2004-06-09 16:32:26 Re: invalid page header
Previous Message Michael Guerin 2004-06-09 13:29:12 invalid page header