Re: Invalid Page Header - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: Invalid Page Header
Date
Msg-id 20060308231741.GA58021@winnie.fuhr.org
Whole thread Raw
In response to Invalid Page Header  ("Christopher A. Goodfellow" <cgoodfellow@tealuxe.com>)
Responses Re: Invalid Page Header  ("Christopher A. Goodfellow" <cgoodfellow@tealuxe.com>)
List pgsql-novice
On Wed, Mar 08, 2006 at 10:39:37AM -0500, Christopher A. Goodfellow wrote:
> I get an "Invalid page header in block 23 of storetransaction_tbl" error on
> my table when running any kind of select.

Something has corrupted part of your table.  If you search the list
archives for "Invalid page header" you'll find suggestions on how
to find the bad block and view its contents as a hex or ASCII dump
(which might or might not be interesting) and how to zero that block
so the database can access the rest of the table without errors (a
destructive process, so don't do it lightly).

http://archives.postgresql.org/

--
Michael Fuhr

pgsql-novice by date:

Previous
From: Patrick Meylemans
Date:
Subject: Re: psql is very slow
Next
From: Noel Faux
Date:
Subject: Re: Invalid Page Header