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:
>
> http:/
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:
http://pubs.opengroup.org/onlinepubs/009695399/functions/strft
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:
> On
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
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 order
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
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
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 wou
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.con
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 order to recycle the log files after 30 days.
--
Regards,
Ragha
10 matches
Mail list logo