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

2013-06-14 Thread Jeff Frost
On 06/13/13 20:44, Jeff Frost wrote: > These are definitely busy systems, but usually not running close to the edge, > I'll see if I can make a test case using pgbench on 9.2.4. I'm afraid my attempts to reproduce were again unsuccessful. :-( -- Sent via pgsql-bugs mailing list (pgsql-bugs@

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

2013-06-13 Thread Jeff Frost
On Jun 13, 2013, at 7:48 PM, Tom Lane wrote: > Jeff Frost writes: >> What I don't understand is the new log file being created from the new >> log_filename setting but then nothing being logged into it. Is it the >> postmaster which creates that file? I would've thought it would be >> the log

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

2013-06-13 Thread Tom Lane
Jeff Frost writes: > What I don't understand is the new log file being created from the new > log_filename setting but then nothing being logged into it. Is it the > postmaster which creates that file? I would've thought it would be > the logger process? Hm, I hadn't focused on that --- that *i

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

2013-06-13 Thread Jeff Frost
On Jun 13, 2013, at 5:16 PM, Tom Lane wrote: > Jeff Frost writes: >> On Jun 13, 2013, at 4:50 PM, Tom Lane wrote: >>> ... 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 a

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

2013-06-13 Thread Alvaro Herrera
Tom Lane wrote: > j...@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 l

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

2013-06-13 Thread Tom Lane
Jeff Frost writes: > On Jun 13, 2013, at 4:50 PM, Tom Lane wrote: >> ... 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. > Interestingly, it will often pick

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

2013-06-13 Thread Jeff Frost
On Jun 13, 2013, at 4:50 PM, Tom Lane wrote: > j...@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 "para

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

2013-06-13 Thread Tom Lane
j...@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 pr

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

2013-06-11 Thread Jeff Frost
On 06/11/13 15:27, j...@pgexperts.com wrote: > The following bug has been logged on the website: > > Bug reference: 8225 > Logged by: Jeff Frost > Email address: j...@pgexperts.com > PostgreSQL version: 9.1.8 > Operating system: various > Description: > > I've seen this

[BUGS] BUG #8225: logging options don't change after reload

2013-06-11 Thread jeff
The following bug has been logged on the website: Bug reference: 8225 Logged by: Jeff Frost Email address: j...@pgexperts.com PostgreSQL version: 9.1.8 Operating system: various Description: I've seen this a few times on client servers but still can't seem to boil it