Re: Recovery Data Cant Be!!!

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: "Edwin Quijada" <listas_quijada(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Recovery Data Cant Be!!!
Date: 2003-11-07 18:25:18
Message-ID: 20031107132518.29f3ab29.threshar@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 07 Nov 2003 18:08:32 +0000
"Edwin Quijada" <listas_quijada(at)hotmail(dot)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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-11-07 18:27:05 Re: int8 primary keys still not using index without manual
Previous Message Edwin Quijada 2003-11-07 18:08:32 Recovery Data Cant Be!!!