Group :: Databases
RPM: postgresql11
Main Changelog Spec Patches Sources Download Gear Bugs and FR Repocop
Patch: 0004-Setup-logging.patch
Download
Download
diff -ruN postgresql.orig/src/backend/utils/misc/postgresql.conf.sample postgresql/src/backend/utils/misc/postgresql.conf.sample
--- postgresql.orig/src/backend/utils/misc/postgresql.conf.sample 2023-03-03 15:52:14.683556387 +0800
+++ postgresql/src/backend/utils/misc/postgresql.conf.sample 2023-03-03 16:03:32.384832766 +0800
@@ -361,23 +361,23 @@
# - 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.
# 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 = 'log' # 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-%Y-%m-%d_%H%M%S.log' # log file name pattern,
# can include strftime() escapes
-#log_file_mode = 0600 # creation mode for log files,
+log_file_mode = 0600 # 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
@@ -389,7 +389,7 @@
# in all cases.
#log_rotation_age = 1d # Automatic rotation of logfiles will
# happen after that time. 0 disables.
-#log_rotation_size = 10MB # Automatic rotation of logfiles will
+log_rotation_size = 10MB # Automatic rotation of logfiles will
# happen after that much log output.
# 0 disables.
@@ -405,7 +405,7 @@
# - When to Log -
-#log_min_messages = warning # values in order of decreasing detail:
+log_min_messages = warning # values in order of decreasing detail:
# debug5
# debug4
# debug3
@@ -445,9 +445,9 @@
#debug_print_rewritten = off
#debug_print_plan = off
#debug_pretty_print = on
-#log_checkpoints = off
-#log_connections = off
-#log_disconnections = off
+log_checkpoints = off
+log_connections = off
+log_disconnections = off
#log_duration = off
#log_error_verbosity = default # terse, default, or verbose messages
#log_hostname = off