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