Postgres Pro
Downloads
Home   >   mailing lists

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 CAEHH7R65bFz_em9hB4QffOWrYYm+u_TC7=nDjpNtgsgTWMqfKw@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>)
Responses Re: How to maintain the csv log files in pg_log directory only forpast 30 days  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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@paquier.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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: ORM
Next
From: Carl Sverre
Date:
Subject: Postgres trigger side-effect is occurring out of order with row-levelsecurity select policy