postgresql-conf.patch

   1 --- postgresql-12.0/src/backend/utils/misc/postgresql.conf.sample       2019-09-30 22:06:55.000000000 +0200
   2 +++ postgresql-12.0/src/backend/utils/misc/postgresql.conf.sample       2019-10-07 21:05:24.551000000 +0200
   3 @@ -416,23 +416,23 @@
   4
   5  # - Where to Log -
   6
   7 -#log_destination = 'stderr'            # Valid values are combinations of
   8 +log_destination = 'stderr'             # Valid values are combinations of
   9                                         # stderr, csvlog, syslog, and eventlog,
  10                                         # depending on platform.  csvlog
  11                                         # requires logging_collector to be on.
  12
  13  # This is used when logging to stderr:
  14 -#logging_collector = off               # Enable capturing of stderr and csvlog
  15 +logging_collector = on                 # Enable capturing of stderr and csvlog
  16                                         # into log files. Required to be on for
  17                                         # csvlogs.
  18                                         # (change requires restart)
  19
  20  # These are only used if logging_collector is on:
  21 -#log_directory = 'log'                 # directory where log files are written,
  22 +log_directory = '/var/log/postgresql'  # directory where log files are written,
  23                                         # can be absolute or relative to PGDATA
  24 -#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'       # log file name pattern,
  25 +log_filename = 'postgresql-12.log'     # log file name pattern,
  26                                         # can include strftime() escapes
  27 -#log_file_mode = 0600                  # creation mode for log files,
  28 +log_file_mode = 0640                   # creation mode for log files,
  29                                         # begin with 0 to use octal notation
  30  #log_truncate_on_rotation = off                # If on, an existing log file with the
  31                                         # same name as the new log file will be
  32 @@ -442,16 +442,16 @@
  33                                         # or size-driven rotation.  Default is
  34                                         # off, meaning append to existing files
  35                                         # in all cases.
  36 -#log_rotation_age = 1d                 # Automatic rotation of logfiles will
  37 +log_rotation_age = 0                   # Automatic rotation of logfiles will
  38                                         # happen after that time.  0 disables.
  39 -#log_rotation_size = 10MB              # Automatic rotation of logfiles will
  40 +log_rotation_size = 0                  # Automatic rotation of logfiles will
  41                                         # happen after that much log output.
  42                                         # 0 disables.
  43
  44  # These are relevant when logging to syslog:
  45 -#syslog_facility = 'LOCAL0'
  46 -#syslog_ident = 'postgres'
  47 -#syslog_sequence_numbers = on
  48 +syslog_facility = 'LOCAL0'
  49 +syslog_ident = 'postgresql-12'
  50 +syslog_sequence_numbers = on
  51  #syslog_split_messages = on
  52
  53  # This is only relevant when logging to eventlog (win32):
  54 @@ -504,12 +504,12 @@
  55  #debug_print_plan = off
  56  #debug_pretty_print = on
  57  #log_checkpoints = off
  58 -#log_connections = off
  59 -#log_disconnections = off
  60 +log_connections = on
  61 +log_disconnections = on
  62  #log_duration = off
  63  #log_error_verbosity = default         # terse, default, or verbose messages
  64  #log_hostname = off
  65 -#log_line_prefix = '%m [%p] '          # special values:
  66 +log_line_prefix = '%m [%p] %q%h/%a %u/%d '     # special values:
  67                                         #   %a = application name
  68                                         #   %u = user name
  69                                         #   %d = database name