Re: BUG #8225: logging options don't change after reload - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #8225: logging options don't change after reload
Date
Msg-id 21308.1371167440@sss.pgh.pa.us
Whole thread Raw
In response to BUG #8225: logging options don't change after reload  (jeff@pgexperts.com)
Responses Re: BUG #8225: logging options don't change after reload
List pgsql-bugs
jeff@pgexperts.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

pgsql-bugs by date:

Previous
From: David Johnston
Date:
Subject: Re: BUG #8228: Unexpected "set-valued function" with varchar(n) but not varchar
Next
From: Jeff Frost
Date:
Subject: Re: BUG #8225: logging options don't change after reload