Re: serverlog rotation/functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: serverlog rotation/functions
Дата
Msg-id 18934.1089754606@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: serverlog rotation/functions  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: serverlog rotation/functions
Re: serverlog rotation/functions
Список pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> However, looking at the issue of backends all reloading their
> postgresql.conf files at different times and sending output to different
> files, I wonder if it would be best to create a log process and have
> each backend connect to that.  That way, all the logging happens in one
> process.

That was something that bothered me too.  I think in the patch as given,
the GUC parameter determining the logfile name would have to be
PGC_POSTMASTER, ie, you could not change it on the fly because the
backends wouldn't all switch together.   There may be some finer-grain
timing issues as well.

On the whole I think that capturing all the backends' stderr via a pipe
and doing the file rotation in a single downstream process is a *much*
cleaner solution.  However, I've been saying that right along and
haven't been listened to...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Is "trust" really a good default?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Is "trust" really a good default?