Re: How to maintain the csv log files in pg_log directory only forpast 30 days

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: How to maintain the csv log files in pg_log directory only forpast 30 days
Дата
Msg-id 568940a5-9a25-d119-b69a-3905cdd61b0b@aklaver.com
обсуждение исходный текст
Ответ на Re: How to maintain the csv log files in pg_log directory only forpast 30 days  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
Ответы Re: How to maintain the csv log files in pg_log directory only forpast 30 days
Список pgsql-general
On 9/28/18 7:05 PM, Raghavendra Rao J S V wrote:
> Hi All,
> 
> Hope you all are recommending below settings to maintain only max 30 
> days logs in *pg_log* directory. Please correct me if I am wrong.

Well it would actually be 31 days as:

http://pubs.opengroup.org/onlinepubs/009695399/functions/strftime.html

%d
     Replaced by the day of the month as a decimal number [01,31]. [ 
tm_mday]

Not sure if that matters or not.

> 
> log_filename = 'postgresql-%d.log'
> log_truncate_on_rotation = 'on',
> 
> Regards,
> Raghavendra Rao
> 
> On Sat, 29 Sep 2018 at 04:24, Michael Paquier <michael@paquier.xyz 
> <mailto:michael@paquier.xyz>> wrote:
> 
>     On Fri, Sep 28, 2018 at 06:19:16AM -0700, Adrian Klaver wrote:
>      > If log_truncate_on_rotation = 'on', correct?
> 
>     Yup, thanks for precising.
>     --
>     Michael
> 
> 
> 
> -- 
> Regards,
> Raghavendra Rao J S V
> Mobile- 8861161425


-- 
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: marcelo
Дата:
Сообщение: Re: ORM
Следующее
От: Arup Rakshit
Дата:
Сообщение: Re: Why my query not using index to sort?