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

From: Jeff Frost <jeff(at)pgexperts(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8225: logging options don't change after reload
Date: 2013-06-14 01:14:05
Message-ID: F221D014-CEF1-4B5A-8D31-735695BBCC34@pgexperts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


On Jun 13, 2013, at 5:16 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Jeff Frost <jeff(at)pgexperts(dot)com> writes:
>> On Jun 13, 2013, at 4:50 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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 them up if you wait a few seconds and send it another reload.
>
> Hmm, that definitely lends some credence to the lost-signal theory,
> since another reload would cause the postmaster to again signal all
> its children, and this time the signal might go through.
>
> But I still have no idea how we might debug further. You could possibly
> try something like strace'ing the processes, but it seems fairly likely
> that the Heisenberg principle would apply if you did.

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?

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-06-14 02:48:10 Re: BUG #8225: logging options don't change after reload
Previous Message Alvaro Herrera 2013-06-14 01:01:02 Re: BUG #8225: logging options don't change after reload