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

From Raghavendra Rao J S V
Subject Re: How to maintain the csv log files in pg_log directory only forpast 30 days
Date
Msg-id CAEHH7R7jgmogNzqqF7xv+UzgBHN804h=tsUtu6Edja3Uk1DLug@mail.gmail.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>)
List pgsql-general
Thanks for the prompt response. 

On Fri 28 Sep, 2018, 10:55 AM Michael Paquier, <michael@paquier.xyz> 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.
--
Michael

pgsql-general by date:

Previous
From: bhargav kamineni
Date:
Subject: Replication Issues
Next
From: Achilleas Mantzios
Date:
Subject: Re: Replication Issues