From 0b93ff7b6e0a9e7baa54218f552c0536b3e8f33c Mon Sep 17 00:00:00 2001

From: Alexei Takaseev <taf@altlinux.org>

Date: Fri, 3 Mar 2023 15:22:18 +0800

Subject: Default enabled logging to file in $PGDATA/log

diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample

index f92ff4cc29..7f0b3be049 100644

--- a/src/backend/utils/misc/postgresql.conf.sample

+++ b/src/backend/utils/misc/postgresql.conf.sample

@@ -441,28 +441,28 @@

 # - Where to Log -

-#log_destination = 'stderr'		# Valid values are combinations of

+log_destination = 'stderr'		# Valid values are combinations of

 					# stderr, csvlog, jsonlog, syslog, and

 					# eventlog, depending on platform.

 					# csvlog and jsonlog require

 					# logging_collector to be on.

 # This is used when logging to stderr:

-#logging_collector = off		# Enable capturing of stderr, jsonlog,

+logging_collector = on		# Enable capturing of stderr, jsonlog,

 					# and csvlog into log files. Required

 					# to be on for csvlogs and jsonlogs.

 					# (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_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.

 #log_truncate_on_rotation = off		# If on, an existing log file with the

@@ -486,7 +486,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

@@ -550,9 +550,9 @@

 					# their durations, > 0 logs only

 					# actions running at least this number

 					# of milliseconds.

-#log_checkpoints = on

-#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