X-Git-Url: https://git.tld-linux.org/?a=blobdiff_plain;f=postgresql-conf.patch;h=30cf68e8e89f6f2e950bb63a05385aad7d513942;hb=refs%2Fheads%2FPGSQL_9_4;hp=ae0ac1ca91e9953a09a0ba079fb15e633702aa7e;hpb=c6f188b0a79186234a5126fda5b80a8946532d04;p=packages%2Fpostgresql.git

diff --git a/postgresql-conf.patch b/postgresql-conf.patch
index ae0ac1c..30cf68e 100644
--- a/postgresql-conf.patch
+++ b/postgresql-conf.patch
@@ -1,31 +1,67 @@
---- postgresql-8.3RC1/src/backend/utils/misc/postgresql.conf.sample.orig	2007-12-07 16:44:56.000000000 +0000
-+++ postgresql-8.3RC1/src/backend/utils/misc/postgresql.conf.sample	2008-01-07 22:19:56.904649611 +0000
-@@ -253,7 +253,7 @@
+--- postgresql-9.4.20/src/backend/utils/misc/postgresql.conf.sample	2018-11-05 21:51:23.000000000 +0000
++++ postgresql-9.4.20/src/backend/utils/misc/postgresql.conf.sample	2018-12-03 13:35:51.047403000 +0000
+@@ -309,23 +309,23 @@
  
  # - 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.
-@@ -262,8 +262,8 @@
- 					# 0 to disable.
+ 
+ # 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 = 'pg_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-9.4.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
+@@ -335,15 +335,15 @@
+ 					# 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.
+-#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.
  
  # These are relevant when logging to syslog:
 -#syslog_facility = 'LOCAL0'
 -#syslog_ident = 'postgres'
 +syslog_facility = 'LOCAL0'
-+syslog_ident = 'postgres'
- 
++syslog_ident = 'postgresql-9.4'
  
- # - When to Log -
-@@ -324,7 +324,7 @@
+ # This is only relevant when logging to eventlog (win32):
+ # (change requires restart)
+@@ -403,12 +403,12 @@
  #debug_print_plan = off
- #debug_pretty_print = off
+ #debug_pretty_print = on
  #log_checkpoints = off
 -#log_connections = off
+-#log_disconnections = off
 +log_connections = on
- #log_disconnections = off
++log_disconnections = on
  #log_duration = off
+ #log_error_verbosity = default		# terse, default, or verbose messages
  #log_hostname = off
+-#log_line_prefix = ''			# special values:
++log_line_prefix = '%m [%p] %q%h/%a %u/%d '	# special values:
+ 					#   %a = application name
+ 					#   %u = user name
+ 					#   %d = database name