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