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

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