postgresql-conf.patch

   1 --- postgresql-15.2/src/backend/utils/misc/postgresql.conf.sample       2023-03-07 23:29:21.289677003 +0100
   2 +++ postgresql-15.2/src/backend/utils/misc/postgresql.conf.sample       2023-03-07 23:32:49.321241168 +0100
   3 @@ -441,28 +441,28 @@
   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, jsonlog, syslog, and
  10                                         # eventlog, depending on platform.
  11                                         # csvlog and jsonlog require
  12                                         # logging_collector to be on.
  13
  14  # This is used when logging to stderr:
  15 -#logging_collector = off               # Enable capturing of stderr, jsonlog,
  16 +logging_collector = on                 # Enable capturing of stderr, jsonlog,
  17                                         # and csvlog into log files. Required
  18                                         # to be on for csvlogs and jsonlogs.
  19                                         # (change requires restart)
  20
  21  # These are only used if logging_collector is on:
  22 -#log_directory = 'log'                 # directory where log files are written,
  23 +log_directory = '/var/log/postgresql'  # directory where log files are written,
  24                                         # can be absolute or relative to PGDATA
  25 -#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'       # log file name pattern,
  26 +log_filename = 'postgresql-15.log'     # log file name pattern,
  27                                         # can include strftime() escapes
  28 -#log_file_mode = 0600                  # creation mode for log files,
  29 +log_file_mode = 0640                   # creation mode for log files,
  30                                         # begin with 0 to use octal notation
  31 -#log_rotation_age = 1d                 # Automatic rotation of logfiles will
  32 +log_rotation_age = 0                   # Automatic rotation of logfiles will
  33                                         # happen after that time.  0 disables.
  34 -#log_rotation_size = 10MB              # Automatic rotation of logfiles will
  35 +log_rotation_size = 0                  # Automatic rotation of logfiles will
  36                                         # happen after that much log output.
  37                                         # 0 disables.
  38  #log_truncate_on_rotation = off                # If on, an existing log file with the
  39 @@ -475,9 +475,9 @@
  40                                         # in all cases.
  41
  42  # These are relevant when logging to syslog:
  43 -#syslog_facility = 'LOCAL0'
  44 -#syslog_ident = 'postgres'
  45 -#syslog_sequence_numbers = on
  46 +syslog_facility = 'LOCAL0'
  47 +syslog_ident = 'postgresql-15'
  48 +syslog_sequence_numbers = on
  49  #syslog_split_messages = on
  50
  51  # This is only relevant when logging to eventlog (Windows):
  52 @@ -551,12 +551,12 @@
  53                                         # actions running at least this number
  54                                         # of milliseconds.
  55  #log_checkpoints = on
  56 -#log_connections = off
  57 -#log_disconnections = off
  58 +log_connections = on
  59 +log_disconnections = on
  60  #log_duration = off
  61  #log_error_verbosity = default         # terse, default, or verbose messages
  62  #log_hostname = off
  63 -#log_line_prefix = '%m [%p] '          # special values:
  64 +#log_line_prefix = '%m [%p] %q%h/%a %u/%d '    # special values:
  65                                         #   %a = application name
  66                                         #   %u = user name
  67                                         #   %d = database name