Re: HD is flooded by Error Log info

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