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

From Abraham, Danny
Subject HD is flooded by Error Log info
Date
Msg-id E9DE7963E5EA6546B42A979EC28B4D01368DB3F1@hou-ex-02.adprod.bmc.com
Whole thread Raw
Responses Re: HD is flooded by Error Log info  ("Usama Dar" <munir.usama@gmail.com>)
Re: HD is flooded by Error Log info  (Simon Riggs <simon@2ndquadrant.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: "Joshua D. Drake"
Date:
Subject: Re: hibernate + postgresql ?
Next
From: "Abraham, Danny"
Date:
Subject: Re: HD is flooded by Error Log info