Runtime configuration: Logging

• server_min_messages: severity of messages written to stderr (lowest to highest: debug5, debug4, debug3, debug2, debug1, info, notice, warning, error, log, fatal, panic)


• client_min_messages: severity of messages sent to client


• log_connections, log_pid, log_statement, log_duration, log_timestamp: log respective data


• log_min_error_statement: severity of error at which the statement inducing the error is logged


• debug_print_parse, debug_print_rewritten, debug_print_plan, debug_pretty_print, explain_pretty_print: what internal data should be logged



• syslog: 0 (off), 1 (write to syslog and stderr), 2 (syslog only)


• syslog_facility: LOCAL[0-7] (see syslog manual)

Page 19