Someone

Here is what I add to the end of /usr/local/pgsql/data/postgresql.conf

Remember to HUP postmaster after doing this change.

#log_duration = on
#log_statement = all


syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
client_min_messages = error
log_min_messages = error
redirect_stderr = on
log_destination = 'stderr,syslog'

log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_rotation_age = 86400
stats_command_string = on
log_line_prefix = '%m %d %p '