Re: HD is flooded by Error Log info

Поиск
Список
Период
Сортировка
От Abraham, Danny
Тема Re: HD is flooded by Error Log info
Дата
Msg-id E9DE7963E5EA6546B42A979EC28B4D01368DB40C@hou-ex-02.adprod.bmc.com
обсуждение исходный текст
Ответ на HD is flooded by Error Log info  ("Abraham, Danny" <danny_abraham@bmc.com>)
Список pgsql-general
Hello

Recently an application endless loop crashed the PG server.
I am looking for the safest way  to limit the growth of the all the files in the “pg_log” directory,
While still  maintain reasonable period of log.

Any suggestions?

Our current setup is:

#---------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#---------------------------------------------------------------------------
redirect_stderr = on
log_line_prefix = '%m'
client_min_messages = error
log_min_messages = error

log_filename = 'CTMD-%d.log
log_truncate_on_rotation = on
log_rotation_age = 1d
log_rotation_size = 10MB


Thanks


Danny Abraham
BMC Software
CTM&D Business Unit
972-52-4286-513
danny_abraham@bmc.com



В списке pgsql-general по дате отправления:

Предыдущее
От: "Abraham, Danny"
Дата:
Сообщение: HD is flooded by Error Log info
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: notify/listen disappearing data