--- postgresql-11.1/src/backend/utils/misc/postgresql.conf.sample 2018-11-06 23:56:26.000000000 +0000 +++ postgresql-11.1/src/backend/utils/misc/postgresql.conf.sample 2018-12-03 13:15:44.113403000 +0000 @@ -361,7 +361,7 @@ # - Where to Log - -#log_destination = 'stderr' # Valid values are combinations of +log_destination = 'syslog' # Valid values are combinations of # stderr, csvlog, syslog, and eventlog, # depending on platform. csvlog # requires logging_collector to be on. @@ -394,9 +394,9 @@ # 0 disables. # These are relevant when logging to syslog: -#syslog_facility = 'LOCAL0' -#syslog_ident = 'postgres' -#syslog_sequence_numbers = on +syslog_facility = 'LOCAL0' +syslog_ident = 'postgresql-11' +syslog_sequence_numbers = on #syslog_split_messages = on # This is only relevant when logging to eventlog (win32): @@ -457,12 +457,12 @@ #debug_print_plan = off #debug_pretty_print = on #log_checkpoints = off -#log_connections = off -#log_disconnections = off +log_connections = on +log_disconnections = on #log_duration = off #log_error_verbosity = default # terse, default, or verbose messages #log_hostname = off -#log_line_prefix = '%m [%p] ' # special values: +log_line_prefix = '%m [%p] %q%h/%a %u/%d ' # special values: # %a = application name # %u = user name # %d = database name