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