Re: Recovery Data Cant Be!!! - Mailing list pgsql-general

From Jeff
Subject Re: Recovery Data Cant Be!!!
Date
Msg-id 20031107132518.29f3ab29.threshar@torgo.978.org
Whole thread Raw
In response to Recovery Data Cant Be!!!  ("Edwin Quijada" <listas_quijada@hotmail.com>)
List pgsql-general
On Fri, 07 Nov 2003 18:08:32 +0000
"Edwin Quijada" <listas_quijada@hotmail.com> wrote:

> LOG:  redo starts at 1/34600358
> PANIC:  Invalid page header in block 8805 of 17097

Hmm.. Does this machine bychance run with fsync=false or an IDE drive?

You may be able to salvage things if you turn zero_damaged_pages on in
postgresql.conf..

but in general it seems your db is corrupt.

You might want to make a copy of $PGDATA before you try the
zero_damaged_pages thingy.



--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

pgsql-general by date:

Previous
From: "Edwin Quijada"
Date:
Subject: Recovery Data Cant Be!!!
Next
From: Bruce Momjian
Date:
Subject: Re: int8 primary keys still not using index without manual