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

2018-09-30 Thread Peter J. Holzer
On 2018-09-29 07:12:32 -0700, Adrian Klaver wrote: > On 9/28/18 7:05 PM, Raghavendra Rao J S V wrote: > > 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. > > Well it would actually be 31 days as: > >

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

2018-09-29 Thread Adrian Klaver
On 9/28/18 7:05 PM, Raghavendra Rao J S V wrote: 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. Well it would actually be 31 days as:

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

2018-09-28 Thread Raghavendra Rao J S V
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 wrote: >

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

2018-09-28 Thread Michael Paquier
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 signature.asc Description: PGP signature

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

2018-09-28 Thread Ron
On 09/28/2018 12:03 AM, Raghavendra Rao J S V wrote: Hi All, 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

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

2018-09-28 Thread Francisco Olarte
On Fri, Sep 28, 2018 at 7:03 AM, 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

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

2018-09-28 Thread Adrian Klaver
On 9/27/18 10:25 PM, Michael Paquier 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

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

2018-09-28 Thread Raghavendra Rao J S V
Thanks for the prompt response. On Fri 28 Sep, 2018, 10:55 AM Michael Paquier, 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

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

2018-09-27 Thread Michael Paquier
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 >