Search Postgresql Archives

HD is flooded by Error Log info

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

 

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux