Re: HD is flooded by Error Log info - Mailing list pgsql-general

From Abraham, Danny
Subject Re: HD is flooded by Error Log info
Date
Msg-id E9DE7963E5EA6546B42A979EC28B4D01368DB40C@hou-ex-02.adprod.bmc.com
Whole thread Raw
In response to HD is flooded by Error Log info  ("Abraham, Danny" <danny_abraham@bmc.com>)
List 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 by date:

Previous
From: "Abraham, Danny"
Date:
Subject: HD is flooded by Error Log info
Next
From: Richard Huxton
Date:
Subject: Re: notify/listen disappearing data