HD is flooded by Error Log info

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

Responses

Browse pgsql-general by date

  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 ?