X-Git-Url: https://git.tld-linux.org/?a=blobdiff_plain;f=postgresql-conf.patch;h=ebedf2df4e5ef623d160aa7d354a0f40e761be19;hb=44705b8f1f91623cb1fa359096a66494d2c3b673;hp=0fc585192f507b964ac2d8b6f6bff3c18ddc661d;hpb=5235c002a93478c77b52184416c2b8db72014e5d;p=packages%2Fpostgresql.git

diff --git a/postgresql-conf.patch b/postgresql-conf.patch
index 0fc5851..ebedf2d 100644
--- a/postgresql-conf.patch
+++ b/postgresql-conf.patch
@@ -1,30 +1,56 @@
---- 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,7 +361,7 @@
+--- 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 @@
  
  # - Where to Log -
  
 -#log_destination = 'stderr'		# Valid values are combinations of
-+log_destination = 'syslog'		# 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.
-@@ -394,9 +394,9 @@
+ 
+ # 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.
+ 					# (change requires restart)
+ 
+ # These are only used if logging_collector is on:
+-#log_directory = 'log'			# directory where log files are written,
++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,
+ 					# 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_rotation_age = 1d			# Automatic rotation of logfiles will
++log_rotation_age = 0			# Automatic rotation of logfiles will
+ 					# happen after that time.  0 disables.
+-#log_rotation_size = 10MB		# Automatic rotation of logfiles will
++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
+@@ -463,9 +463,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-14'
 +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
+ # This is only relevant when logging to eventlog (Windows):
+@@ -534,12 +534,12 @@
+ 					# actions running at least this number
+ 					# of milliseconds.
  #log_checkpoints = off
 -#log_connections = off
 -#log_disconnections = off