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

From: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
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 06:13:19
Message-ID: CAEHH7R7jgmogNzqqF7xv+UzgBHN804h=tsUtu6Edja3Uk1DLug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks for the prompt response.

On Fri 28 Sep, 2018, 10:55 AM Michael Paquier, <michael(at)paquier(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2018-09-28 06:29:10 Re: Replication Issues
Previous Message bhargav kamineni 2018-09-28 06:00:41 Replication Issues