postgresql-conf.patch

   1 --- postgresql-11.1/src/backend/utils/misc/postgresql.conf.sample       2018-11-06 23:56:26.000000000 +0000
   2 +++ postgresql-11.1/src/backend/utils/misc/postgresql.conf.sample       2018-12-03 13:15:44.113403000 +0000
   3 @@ -361,7 +361,7 @@
   4
   5  # - Where to Log -
   6
   7 -#log_destination = 'stderr'            # Valid values are combinations of
   8 +log_destination = 'syslog'             # Valid values are combinations of
   9                                         # stderr, csvlog, syslog, and eventlog,
  10                                         # depending on platform.  csvlog
  11                                         # requires logging_collector to be on.
  12 @@ -394,9 +394,9 @@
  13                                         # 0 disables.
  14
  15  # These are relevant when logging to syslog:
  16 -#syslog_facility = 'LOCAL0'
  17 -#syslog_ident = 'postgres'
  18 -#syslog_sequence_numbers = on
  19 +syslog_facility = 'LOCAL0'
  20 +syslog_ident = 'postgresql-11'
  21 +syslog_sequence_numbers = on
  22  #syslog_split_messages = on
  23
  24  # This is only relevant when logging to eventlog (win32):
  25 @@ -457,12 +457,12 @@
  26  #debug_print_plan = off
  27  #debug_pretty_print = on
  28  #log_checkpoints = off
  29 -#log_connections = off
  30 -#log_disconnections = off
  31 +log_connections = on
  32 +log_disconnections = on
  33  #log_duration = off
  34  #log_error_verbosity = default         # terse, default, or verbose messages
  35  #log_hostname = off
  36 -#log_line_prefix = '%m [%p] '          # special values:
  37 +log_line_prefix = '%m [%p] %q%h/%a %u/%d '     # special values:
  38                                         #   %a = application name
  39                                         #   %u = user name
  40                                         #   %d = database name