- updated to 16.2

[packages/postgresql.git] / postgresql-conf.patch

diff --git a/postgresql-conf.patch b/postgresql-conf.patch
index b36b9f0454187b3c6bf6eb8c3545d3dac840c2a3..b56d003624689aa8f7cafba12c9cb66bcf959e6f 100644 (file)
--- a/postgresql-conf.patch
+++ b/postgresql-conf.patch
@@ -1,20 +1,21 @@
---- postgresql-11.1/src/backend/utils/misc/postgresql.conf.sample      2018-11-06 23:56:26.000000000 +0000
-+++ postgresql-11.1/src/backend/utils/misc/postgresql.conf.sample      2018-12-03 13:15:44.113403000 +0000
-@@ -361,23 +361,23 @@
+--- postgresql-16.1/src/backend/utils/misc/postgresql.conf.sample      2023-11-06 23:04:27.000000000 +0100
++++ postgresql-16.1/src/backend/utils/misc/postgresql.conf.sample      2023-12-16 01:39:41.030887367 +0100
+@@ -447,28 +447,28 @@
  
  # - Where to Log -
  
 -#log_destination = 'stderr'           # Valid values are combinations of
 +log_destination = 'stderr'            # Valid values are combinations of
-                                       # stderr, csvlog, syslog, and eventlog,
-                                       # depending on platform.  csvlog
-                                       # requires logging_collector to be on.
+                                       # stderr, csvlog, jsonlog, syslog, and
+                                       # eventlog, depending on platform.
+                                       # csvlog and jsonlog require
+                                       # logging_collector to be on.
  
  # This is used when logging to stderr:
--#logging_collector = off              # Enable capturing of stderr and csvlog
-+logging_collector = on                        # Enable capturing of stderr and csvlog
-                                       # into log files. Required to be on for
-                                       # csvlogs.
+-#logging_collector = off              # Enable capturing of stderr, jsonlog,
++logging_collector = on                        # Enable capturing of stderr, jsonlog,
+                                       # and csvlog into log files. Required
+                                       # to be on for csvlogs and jsonlogs.
                                        # (change requires restart)
  
  # These are only used if logging_collector is on:
@@ -22,17 +23,11 @@
 +log_directory = '/var/log/postgresql' # directory where log files are written,
                                        # can be absolute or relative to PGDATA
 -#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'      # log file name pattern,
-+log_filename = 'postgresql-11.log'    # log file name pattern,
++log_filename = 'postgresql-16.log'    # log file name pattern,
                                        # can include strftime() escapes
 -#log_file_mode = 0600                 # creation mode for log files,
 +log_file_mode = 0640                  # creation mode for log files,
                                        # begin with 0 to use octal notation
- #log_truncate_on_rotation = off               # If on, an existing log file with the
-                                       # same name as the new log file will be
-@@ -387,16 +387,16 @@
-                                       # or size-driven rotation.  Default is
-                                       # off, meaning append to existing files
-                                       # in all cases.
 -#log_rotation_age = 1d                        # Automatic rotation of logfiles will
 +log_rotation_age = 0                  # Automatic rotation of logfiles will
                                        # happen after that time.  0 disables.
@@ -40,21 +35,24 @@
 +log_rotation_size = 0                 # Automatic rotation of logfiles will
                                        # happen after that much log output.
                                        # 0 disables.
+ #log_truncate_on_rotation = off               # If on, an existing log file with the
+@@ -481,9 +481,9 @@
+                                       # in all cases.
  
  # These are relevant when logging to syslog:
 -#syslog_facility = 'LOCAL0'
 -#syslog_ident = 'postgres'
 -#syslog_sequence_numbers = on
 +syslog_facility = 'LOCAL0'
-+syslog_ident = 'postgresql-11'
++syslog_ident = 'postgresql-16'
 +syslog_sequence_numbers = on
  #syslog_split_messages = on
  
- # This is only relevant when logging to eventlog (win32):
-@@ -457,12 +457,12 @@
- #debug_print_plan = off
- #debug_pretty_print = on
- #log_checkpoints = off
+ # This is only relevant when logging to eventlog (Windows):
+@@ -557,12 +557,12 @@
+                                       # actions running at least this number
+                                       # of milliseconds.
+ #log_checkpoints = on
 -#log_connections = off
 -#log_disconnections = off
 +log_connections = on
@@ -63,7 +61,7 @@
  #log_error_verbosity = default                # terse, default, or verbose messages
  #log_hostname = off
 -#log_line_prefix = '%m [%p] '         # special values:
-+log_line_prefix = '%m [%p] %q%h/%a %u/%d '    # special values:
++#log_line_prefix = '%m [%p] %q%h/%a %u/%d '   # special values:
                                        #   %a = application name
                                        #   %u = user name
                                        #   %d = database name