On Friday 01 June 2007 3:36 pm, Tom Lane wrote:
> What *exactly* is the logging setup you guys use, and have you
> tried alternatives?
redirect_stderr = on # Enable capturing of stderr into log
log_directory = '/users/.../logs' # Directory where log files are written
log_filename = 'server_log.%a.%H:00-%H:59' # Log file name pattern.
log_truncate_on_rotation = on # If on, any existing log file of the same
log_rotation_age = 60min # Automatic rotation of logfiles will
log_min_messages = notice # Values, in order of decreasing detail:
log_connections = on
log_disconnections = on
log_duration = on
log_line_prefix = '%m [%p] %u %r %d ' # Special values:
log_statement = 'all' # none, ddl, mod, all
I have not tried alternatives. The status quo is adequate.
Ed
