postgresql-conf.patch

   1 --- postgresql-9.5.15/src/backend/utils/misc/postgresql.conf.sample     2018-11-05 21:49:29.000000000 +0000
   2 +++ postgresql-9.5.15/src/backend/utils/misc/postgresql.conf.sample     2018-12-03 13:32:36.483403000 +0000
   3 @@ -315,23 +315,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 = 'pg_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-9.5.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 @@ -341,15 +341,15 @@
  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_facility = 'LOCAL0'
  48 +syslog_ident = 'postgresql-9.5'
  49
  50  # This is only relevant when logging to eventlog (win32):
  51  # (change requires restart)
  52 @@ -409,12 +409,12 @@
  53  #debug_print_plan = off
  54  #debug_pretty_print = on
  55  #log_checkpoints = off
  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 = ''                  # 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