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: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, 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-29 02:05:58
Message-ID: CAEHH7R65bFz_em9hB4QffOWrYYm+u_TC7=nDjpNtgsgTWMqfKw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

log_filename = 'postgresql-%d.log'
log_truncate_on_rotation = 'on',

Regards,
Raghavendra Rao

On Sat, 29 Sep 2018 at 04:24, Michael Paquier <michael(at)paquier(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Carl Sverre 2018-09-29 06:35:44 Postgres trigger side-effect is occurring out of order with row-level security select policy
Previous Message Adrian Klaver 2018-09-29 00:39:07 Re: ORM