- updated to 11.20

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

diff --git a/postgresql-conf.patch b/postgresql-conf.patch
index 0fc585192f507b964ac2d8b6f6bff3c18ddc661d..b36b9f0454187b3c6bf6eb8c3545d3dac840c2a3 100644 (file)
--- a/postgresql-conf.patch
+++ b/postgresql-conf.patch
@@ -1,15 +1,44 @@
 --- 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 @@
+@@ -361,23 +361,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.
-@@ -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-11.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.
+-#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: