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. +

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to