Re: Invalid Page Header

I have read quite a bit in the archives and it seems the best way is to
zero_damaged_pages.  I did a search for zero_damaged_pages.  Is it as simple
as adding zero_damaged_pages to postgresql.conf and restarting the
postmaster?



Thank You,
Christopher A. Goodfellow
Corporate Director
Tealuxe, Inc.
Phone:  508-520-7887
Fax:  508-528-8999
Tea For All


-----Original Message-----
From: Michael Fuhr [mailto:mike@fuhr.org]
Sent: Wednesday, March 08, 2006 6:18 PM
To: Christopher A. Goodfellow
Cc: Pgsql-Novice (E-mail)
Subject: Re: [NOVICE] Invalid Page Header


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