Re: How to maintain the csv log files in pg_log directory only forpast 30 days - Mailing list pgsql-general

From Adrian Klaver
Subject Re: How to maintain the csv log files in pg_log directory only forpast 30 days
Date
Msg-id 93d6c6ec-141e-70a4-7b15-7c4b1ba4f146@aklaver.com
Whole thread Raw
In response to Re: How to maintain the csv log files in pg_log directory only forpast 30 days  (Michael Paquier <michael@paquier.xyz>)
Responses Re: How to maintain the csv log files in pg_log directory only forpast 30 days  (Michael Paquier <michael@paquier.xyz>)
List pgsql-general
On 9/27/18 10:25 PM, Michael Paquier wrote:
> On Fri, Sep 28, 2018 at 10:33:30AM +0530, Raghavendra Rao J S V wrote:
>> Log file will be generated in *csv* format at *pg_log* directory in our
>> PostgreSQL. Every day we are getting one log file. We would like to
>> maintain only max 30 days. Which setting need to modify by us in
>> “postgresql.conf” in order to recycle the log files after 30 days.
> 
> If you use for example log_filename = 'postgresql-%d.log', then the
> server uses one new file every day.  This truncates the contents from
> the last month automatically.

If log_truncate_on_rotation = 'on', correct?

> --
> Michael
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Ravi Krishna
Date:
Subject: Re: Why my query not using index to sort?
Next
From: Arup Rakshit
Date:
Subject: Re: Why my query not using index to sort?