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

From Bruce Momjian
Subject Re: Recovery Data Cant Be!!!
Date
Msg-id 200311072059.hA7Kx7k25442@candle.pha.pa.us
Whole thread Raw
In response to Re: Recovery Data Cant Be!!!  ("Edwin Quijada" <listas_quijada@hotmail.com>)
Responses Re: Recovery Data Cant Be!!!
List pgsql-general
Edwin Quijada wrote:
>
> Where set zero_damaged_pages ??

You can't set it from postgresql.conf.  It has to be set in your psql
session:

    SET zero_damaged_pages = true;

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Recovery Data Cant Be!!!
Next
From: Boris Popov
Date:
Subject: Temp rows - is it possible?