Re: Invalid Page Header

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Christopher A(dot) Goodfellow" <cgoodfellow(at)tealuxe(dot)com>
Cc: "Pgsql-Novice (E-mail)" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Invalid Page Header
Date: 2006-03-08 23:17:41
Message-ID: 20060308231741.GA58021@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Noel Faux 2006-03-09 00:38:40 Re: Invalid Page Header
Previous Message Patrick Meylemans 2006-03-08 21:43:02 Re: psql is very slow