---- postgresql-14.0/src/backend/utils/misc/postgresql.conf.sample 2021-11-01 12:40:10.778965880 +0100
-+++ postgresql-14.0/src/backend/utils/misc/postgresql.conf.sample 2021-11-01 14:01:02.459020587 +0100
-@@ -430,27 +430,27 @@
+--- postgresql-15.2/src/backend/utils/misc/postgresql.conf.sample 2023-03-07 23:29:21.289677003 +0100
++++ postgresql-15.2/src/backend/utils/misc/postgresql.conf.sample 2023-03-07 23:32:49.321241168 +0100
+@@ -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, syslog, and eventlog,
- # depending on platform. csvlog
- # requires logging_collector to be on.
+ # 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 and csvlog
-+logging_collector = on # Enable capturing of stderr and csvlog
- # into log files. Required to be on for
- # csvlogs.
+-#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 = '/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-14.log' # log file name pattern,
++log_filename = 'postgresql-15.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,
# happen after that much log output.
# 0 disables.
#log_truncate_on_rotation = off # If on, an existing log file with the
-@@ -463,9 +463,9 @@
+@@ -475,9 +475,9 @@
# in all cases.
# These are relevant when logging to syslog:
-#syslog_ident = 'postgres'
-#syslog_sequence_numbers = on
+syslog_facility = 'LOCAL0'
-+syslog_ident = 'postgresql-14'
++syslog_ident = 'postgresql-15'
+syslog_sequence_numbers = on
#syslog_split_messages = on
# This is only relevant when logging to eventlog (Windows):
-@@ -534,12 +534,12 @@
+@@ -551,12 +551,12 @@
# actions running at least this number
# of milliseconds.
- #log_checkpoints = off
+ #log_checkpoints = on
-#log_connections = off
-#log_disconnections = off
+log_connections = on
#log_error_verbosity = default # terse, default, or verbose messages
#log_hostname = off
-#log_line_prefix = '%m [%p] ' # special values:
-+log_line_prefix = '%m [%p] %q%h/%a %u/%d ' # special values:
++#log_line_prefix = '%m [%p] %q%h/%a %u/%d ' # special values:
# %a = application name
# %u = user name
# %d = database name