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