In postgresql am change following settings for postgresql.conf file.But,logging file is display empty.I want to log all error returned from postgresql.
log_destination = 'stderr,csvlog,syslog'
logging_collector = on
log_directory = 'pg_log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
syslog_facility = 'LOCAL7'
syslog_ident = 'postgres' log_min_duration_statement = 0
log_statement = 'all'
Set the following:
log_min_error_statement = error
log_min_messages = error
Don't forget to run pg_ctl reload after changing postgresql.conf.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With