Postgres Pro
Downloads
Home   >   mailing lists

Re: Limiting the no. of logs file generated by postgreSQL - Mailing list pgsql-admin

From merina ghoghwani
Subject Re: Limiting the no. of logs file generated by postgreSQL
Date
Msg-id CAKoQ0XEJLafsm+vtiZ1UHiJVAoyXpLx43bNiJmyZyF2ehSGAew@mail.gmail.com
Whole thread Raw
In response to Re: Limiting the no. of logs file generated by postgreSQL  (pavan95 <pavan.postgresdba@gmail.com>)
Responses Re: Limiting the no. of logs file generated by postgreSQL  (pavan95 <pavan.postgresdba@gmail.com>)
List pgsql-admin
Tree view
Hi Pavan,

At the time of the outage, the logs were off. I am assuming, the logs increased because I am using replication.

Below is the postgresql.conf, 


log_destination = 'stderr' 
logging_collector = on 
log_filename = 'postgresql-%a.log'
log_statement = 'none'

All other parameters are default values.




On Thu, Feb 15, 2018 at 6:09 PM, pavan95 <pavan.postgresdba@gmail.com> wrote:
Hello Merina,

Firstly, did you observe the log files like what is getting logged?  In case
check whether it is logging all the statements ran on the server..!

This will be caused because of the parameter "log_statements".

What is the value of 'log_statements ' set in your configuration file
'postgresql.conf'?

I think because of this parameters this is increasing the size of the log
files.  You can cross verify over that area.

For further analysis provide the snap of Error Reporting and Logging
parameters.!

Regards,
Pavan.



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html



pgsql-admin by date:

Previous
From: pavan95
Date:
Subject: Re: Limiting the no. of logs file generated by postgreSQL
Next
From: pavan95
Date:
Subject: Re: Limiting the no. of logs file generated by postgreSQL