X-Git-Url: https://git.tld-linux.org/?a=blobdiff_plain;f=postgresql-conf.patch;h=a7ebc92c4de4b751bd6683330cc927fefb54c3fc;hb=33fb7b876d5aa1de50c7058ca6d1ef3f4b3fb424;hp=68474cfd43623a664cd743de6954b884eae07b5b;hpb=28c84373ba0d4e62653d7d3e4f626f790eed3c8d;p=packages%2Fpostgresql.git

diff --git a/postgresql-conf.patch b/postgresql-conf.patch
index 68474cf..a7ebc92 100644
--- a/postgresql-conf.patch
+++ b/postgresql-conf.patch
@@ -1,6 +1,6 @@
---- 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.6.11/src/backend/utils/misc/postgresql.conf.sample	2018-11-05 21:47:37.000000000 +0000
++++ postgresql-9.6.11/src/backend/utils/misc/postgresql.conf.sample	2018-12-03 13:26:39.696403000 +0000
+@@ -329,7 +329,7 @@
  
  # - Where to Log -
  
@@ -9,7 +9,7 @@
  					# stderr, csvlog, syslog, and eventlog,
  					# depending on platform.  csvlog
  					# requires logging_collector to be on.
-@@ -262,8 +262,8 @@
+@@ -362,9 +362,9 @@
  					# 0 disables.
  
  # These are relevant when logging to syslog:
@@ -17,17 +17,24 @@
 -#syslog_ident = 'postgres'
 -#syslog_sequence_numbers = on
 +syslog_facility = 'LOCAL0'
-+syslog_ident = 'postgres-9.6'
++syslog_ident = 'postgresql-9.6'
 +syslog_sequence_numbers = on
  #syslog_split_messages = on
  
  # This is only relevant when logging to eventlog (win32):
-@@ -324,7 +324,7 @@
+@@ -425,12 +425,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