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@xxxxxxx
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
