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

Поиск
Список
Период
Сортировка
От merina ghoghwani
Тема Re: Limiting the no. of logs file generated by postgreSQL
Дата
Msg-id CAKoQ0XEJLafsm+vtiZ1UHiJVAoyXpLx43bNiJmyZyF2ehSGAew@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Limiting the no. of logs file generated by postgreSQL  (pavan95 <pavan.postgresdba@gmail.com>)
Ответы Re: Limiting the no. of logs file generated by postgreSQL
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: pavan95
Дата:
Сообщение: Re: Limiting the no. of logs file generated by postgreSQL
Следующее
От: pavan95
Дата:
Сообщение: Re: Limiting the no. of logs file generated by postgreSQL