Re: Invalid Page Headers

From: "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Invalid Page Headers
Date: 2006-04-18 19:45:33
Message-ID: C2B4E2FA-1C42-4C21-97DF-3CB6D3CAB4BF@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Apr 18, 2006, at 2:15 PM, Tom Lane wrote:

> "Thomas F. O'Connell" <tfo(at)sitening(dot)com> writes:
>> I would've expected the RAID to protect postgres from the possibility
>> of data corruption, but I guess not.
>
> Ooops :-(. It might be interesting to get pg_filedump dumps of the
> corrupted pages, just to see what the failure pattern looks like.
> I doubt there's much we can do about it, but you don't know till you
> look. ("If we knew what it was we were doing, it wouldn't be
> research.")

I'm still looking into what actually caused the hardware failures and
how it could've reached a level where it would've affected postgres.

I'll grab pg_filedump and report back.

In the meantime, should I leave the database online while I attempt
to recover? It's still unclear to me whether postgres will restart
with invalid page headers. I certainly can't run pg_dumpall, for
instance.

I'm glad that there have so far been only 3 relations affected... :(

--
Thomas F. O'Connell
Database Architecture and Programming
Sitening, LLC

http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-04-18 19:57:55 Re: Invalid Page Headers
Previous Message Tom Lane 2006-04-18 19:15:26 Re: Invalid Page Headers