X-Git-Url: https://git.tld-linux.org/?p=packages%2Fpostgresql.git;a=blobdiff_plain;f=postgresql-conf.patch;h=396bebe82e88c078d6f7467df4121d48ede10edf;hp=ebedf2df4e5ef623d160aa7d354a0f40e761be19;hb=HEAD;hpb=e91dafec9b0903bad6593b54c939b8dde755b243

diff --git a/postgresql-conf.patch b/postgresql-conf.patch
index ebedf2d..b56d003 100644
--- a/postgresql-conf.patch
+++ b/postgresql-conf.patch
@@ -1,20 +1,21 @@
---- postgresql-14.0/src/backend/utils/misc/postgresql.conf.sample	2021-11-01 12:40:10.778965880 +0100
-+++ postgresql-14.0/src/backend/utils/misc/postgresql.conf.sample	2021-11-01 14:01:02.459020587 +0100
-@@ -430,27 +430,27 @@
+--- 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,7 +23,7 @@
 +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-14.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,
@@ -35,7 +36,7 @@
  					# happen after that much log output.
  					# 0 disables.
  #log_truncate_on_rotation = off		# If on, an existing log file with the
-@@ -463,9 +463,9 @@
+@@ -481,9 +481,9 @@
  					# in all cases.
  
  # These are relevant when logging to syslog:
@@ -43,15 +44,15 @@
 -#syslog_ident = 'postgres'
 -#syslog_sequence_numbers = on
 +syslog_facility = 'LOCAL0'
-+syslog_ident = 'postgresql-14'
++syslog_ident = 'postgresql-16'
 +syslog_sequence_numbers = on
  #syslog_split_messages = on
  
  # This is only relevant when logging to eventlog (Windows):
-@@ -534,12 +534,12 @@
+@@ -557,12 +557,12 @@
  					# actions running at least this number
  					# of milliseconds.
- #log_checkpoints = off
+ #log_checkpoints = on
 -#log_connections = off
 -#log_disconnections = off
 +log_connections = on
@@ -60,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