Re: BUG #8225: logging options don't change after reload

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jeff(at)pgexperts(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8225: logging options don't change after reload
Date: 2013-06-13 23:50:40
Message-ID: 21308.1371167440@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

jeff(at)pgexperts(dot)com writes:
> What happens is that we change various logging options in postgresql.conf,
> then reload, and every so often, the settings don't seem to take effect even
> though they are logged as being changed.

FWIW, the "parameter changed" messages are logged when the postmaster
process updates its values of the GUCs. The particular options you're
complaining of here, though, are not actually checked in the postmaster
--- they're used in the checkpointer or syslogger processes
respectively. So one theory about this would be that those processes
aren't absorbing the GUC updates, perhaps because the SIGHUP signals the
postmaster should be sending them are getting lost. I'm not sure how we
might track down the cause though. How "various" are the platforms
you're seeing this on?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Frost 2013-06-14 00:01:49 Re: BUG #8225: logging options don't change after reload
Previous Message Tom Lane 2013-06-13 21:44:01 Re: BUG #8228: Unexpected "set-valued function" with varchar(n) but not varchar