postgresql-conf.patch

   1 --- postgresql-14.0/src/backend/utils/misc/postgresql.conf.sample       2021-11-01 12:40:10.778965880 +0100
   2 +++ postgresql-14.0/src/backend/utils/misc/postgresql.conf.sample       2021-11-01 14:01:02.459020587 +0100
   3 @@ -430,27 +430,27 @@
   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-14.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_rotation_age = 1d                 # Automatic rotation of logfiles will
  31 +log_rotation_age = 0                   # Automatic rotation of logfiles will
  32                                         # happen after that time.  0 disables.
  33 -#log_rotation_size = 10MB              # Automatic rotation of logfiles will
  34 +log_rotation_size = 0                  # Automatic rotation of logfiles will
  35                                         # happen after that much log output.
  36                                         # 0 disables.
  37  #log_truncate_on_rotation = off                # If on, an existing log file with the
  38 @@ -463,9 +463,9 @@
  39                                         # in all cases.
  40
  41  # These are relevant when logging to syslog:
  42 -#syslog_facility = 'LOCAL0'
  43 -#syslog_ident = 'postgres'
  44 -#syslog_sequence_numbers = on
  45 +syslog_facility = 'LOCAL0'
  46 +syslog_ident = 'postgresql-14'
  47 +syslog_sequence_numbers = on
  48  #syslog_split_messages = on
  49
  50  # This is only relevant when logging to eventlog (Windows):
  51 @@ -534,12 +534,12 @@
  52                                         # actions running at least this number
  53                                         # of milliseconds.
  54  #log_checkpoints = off
  55 -#log_connections = off
  56 -#log_disconnections = off
  57 +log_connections = on
  58 +log_disconnections = on
  59  #log_duration = off
  60  #log_error_verbosity = default         # terse, default, or verbose messages
  61  #log_hostname = off
  62 -#log_line_prefix = '%m [%p] '          # special values:
  63 +log_line_prefix = '%m [%p] %q%h/%a %u/%d '     # special values:
  64                                         #   %a = application name
  65                                         #   %u = user name
  66                                         #   %d = database name