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

Поиск
Список
Период
Сортировка
От Jeff Frost
Тема Re: BUG #8225: logging options don't change after reload
Дата
Msg-id F221D014-CEF1-4B5A-8D31-735695BBCC34@pgexperts.com
обсуждение исходный текст
Ответ на BUG #8225: logging options don't change after reload  (jeff@pgexperts.com)
Ответы Re: BUG #8225: logging options don't change after reload  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Jun 13, 2013, at 5:16 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Jeff Frost <jeff@pgexperts.com> writes:
>> On Jun 13, 2013, at 4:50 PM, Tom Lane <tgl@sss.pgh.pa.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.
>=20
>> Interestingly, it will often pick them up if you wait a few seconds =
and send it another reload.
>=20
> 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.
>=20
> 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?=

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #8225: logging options don't change after reload
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #8225: logging options don't change after reload