Where set zero_damaged_pages ??
*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo comun"
*-------------------------------------------------------*
From: Jeff <[EMAIL PROTECTED]> To: "Edwin Quijada" <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: [GENERAL] Recovery Data Cant Be!!! Date: Fri, 7 Nov 2003 13:25:18 -0500
On Fri, 07 Nov 2003 18:08:32 +0000 "Edwin Quijada" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/
_________________________________________________________________
Las mejores tiendas, los precios mas bajos, entregas en todo el mundo, YupiMSN Compras: www.yupimsn.com/compras
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
