Re: [HACKERS] Zeroing damaged pages

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
>
> > +     /* Even if zero_damaged_pages is true, we don't want autovacuum zeroing. */
> > +     zero_damaged_pages = false;
>
> This is completely incorrect; you need to set the variable via GUC, else
> it will still be overridden from postgresql.conf if a SIGHUP arrives.
> I believe this would work:
>
>     SetConfigOption("zero_damaged_pages", "false",
>             PGC_SUSET, PGC_S_SESSION);

Done.

--
  Bruce Momjian   http://candle.pha.pa.us
  SRA OSS, Inc.   http://www.sraoss.com

  + If your life is a hard drive, Christ can be your backup. +