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

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to maintain the csv log files in pg_log directory only for past 30 days
Date: 2018-09-28 05:25:39
Message-ID: 20180928052539.GJ1500@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bhargav kamineni 2018-09-28 06:00:41 Replication Issues
Previous Message Laurenz Albe 2018-09-28 05:23:59 Re: Out of Memory