Re: Recovery Data Cant Be!!!

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 <threshar@torgo.978.org>
>To: "Edwin Quijada" <listas_quijada@hotmail.com>
>CC: pgsql-general@postgresql.org
>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" <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/

_________________________________________________________________
Las mejores tiendas, los precios mas bajos, entregas en todo el mundo,
YupiMSN Compras: www.yupimsn.com/compras