From: | "Abraham, Danny" <danny_abraham(at)bmc(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | HD is flooded by Error Log info |
Date: | 2007-11-29 15:53:09 |
Message-ID: | E9DE7963E5EA6546B42A979EC28B4D01368DB3F1@hou-ex-02.adprod.bmc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)bmc(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Abraham, Danny | 2007-11-29 15:58:34 | Re: HD is flooded by Error Log info |
Previous Message | Joshua D. Drake | 2007-11-29 15:52:43 | Re: hibernate + postgresql ? |