Re: Limiting the no. of logs file generated by postgreSQL

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(dot)postgresdba(at)gmail(dot)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
>
>