Re: serverlog rotation/functions

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема Re: serverlog rotation/functions
Дата
Msg-id 40F54B62.7050409@pse-consulting.de
обсуждение исходный текст
Ответ на Re: serverlog rotation/functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Tom Lane wrote:

> That struck me as not only useless but the deliberately hard way to do
> it.  To use that in the real world, you'd have to set up a cron job to
> trigger the rotation,

Still on my radar...

  which means a lot of infrastructure and privilege;
> whereas ISTM the point of this feature was to avoid both.

... I was thinking about putting this into the pg_autovacuum process.

  The log
> capture process should just do its own rotation on a pre-configured
> time-interval basis, and/or maximum-file-size basis.
Yup.

  I see zero value
> added in having it respond to external signals.

I see >0 value. I like to truncate my logfile before doing some
complicated stuff, to have a handy file for debugging purposes.

Regards,
Andreas

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PITR Archive Recovery plus WIP PITR
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: build infrastructure for extensions v3