1 --- postgresql-16.1/src/backend/utils/misc/postgresql.conf.sample 2023-11-06 23:04:27.000000000 +0100
2 +++ postgresql-16.1/src/backend/utils/misc/postgresql.conf.sample 2023-12-16 01:39:41.030887367 +0100
7 -#log_destination = 'stderr' # Valid values are combinations of
8 +log_destination = 'stderr' # Valid values are combinations of
9 # stderr, csvlog, jsonlog, syslog, and
10 # eventlog, depending on platform.
11 # csvlog and jsonlog require
12 # logging_collector to be on.
14 # This is used when logging to stderr:
15 -#logging_collector = off # Enable capturing of stderr, jsonlog,
16 +logging_collector = on # Enable capturing of stderr, jsonlog,
17 # and csvlog into log files. Required
18 # to be on for csvlogs and jsonlogs.
19 # (change requires restart)
21 # These are only used if logging_collector is on:
22 -#log_directory = 'log' # directory where log files are written,
23 +log_directory = '/var/log/postgresql' # directory where log files are written,
24 # can be absolute or relative to PGDATA
25 -#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern,
26 +log_filename = 'postgresql-16.log' # log file name pattern,
27 # can include strftime() escapes
28 -#log_file_mode = 0600 # creation mode for log files,
29 +log_file_mode = 0640 # creation mode for log files,
30 # begin with 0 to use octal notation
31 -#log_rotation_age = 1d # Automatic rotation of logfiles will
32 +log_rotation_age = 0 # Automatic rotation of logfiles will
33 # happen after that time. 0 disables.
34 -#log_rotation_size = 10MB # Automatic rotation of logfiles will
35 +log_rotation_size = 0 # Automatic rotation of logfiles will
36 # happen after that much log output.
38 #log_truncate_on_rotation = off # If on, an existing log file with the
42 # These are relevant when logging to syslog:
43 -#syslog_facility = 'LOCAL0'
44 -#syslog_ident = 'postgres'
45 -#syslog_sequence_numbers = on
46 +syslog_facility = 'LOCAL0'
47 +syslog_ident = 'postgresql-16'
48 +syslog_sequence_numbers = on
49 #syslog_split_messages = on
51 # This is only relevant when logging to eventlog (Windows):
53 # actions running at least this number
56 -#log_connections = off
57 -#log_disconnections = off
59 +log_disconnections = on
61 #log_error_verbosity = default # terse, default, or verbose messages
63 -#log_line_prefix = '%m [%p] ' # special values:
64 +#log_line_prefix = '%m [%p] %q%h/%a %u/%d ' # special values:
65 # %a = application name