1 --- postgresql-9.6.11/src/backend/utils/misc/postgresql.conf.sample 2018-11-05 21:47:37.000000000 +0000
2 +++ postgresql-9.6.11/src/backend/utils/misc/postgresql.conf.sample 2018-12-03 13:26:39.696403000 +0000
7 -#log_destination = 'stderr' # Valid values are combinations of
8 +log_destination = 'stderr' # Valid values are combinations of
9 # stderr, csvlog, syslog, and eventlog,
10 # depending on platform. csvlog
11 # requires logging_collector to be on.
13 # This is used when logging to stderr:
14 -#logging_collector = off # Enable capturing of stderr and csvlog
15 +logging_collector = on # Enable capturing of stderr and csvlog
16 # into log files. Required to be on for
18 # (change requires restart)
20 # These are only used if logging_collector is on:
21 -#log_directory = 'pg_log' # directory where log files are written,
22 +log_directory = '/var/log/postgresql' # directory where log files are written,
23 # can be absolute or relative to PGDATA
24 -#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern,
25 +log_filename = 'postgresql-9.6.log' # log file name pattern,
26 # can include strftime() escapes
27 -#log_file_mode = 0600 # creation mode for log files,
28 +log_file_mode = 0640 # creation mode for log files,
29 # begin with 0 to use octal notation
30 #log_truncate_on_rotation = off # If on, an existing log file with the
31 # same name as the new log file will be
33 # or size-driven rotation. Default is
34 # off, meaning append to existing files
36 -#log_rotation_age = 1d # Automatic rotation of logfiles will
37 +log_rotation_age = 0 # Automatic rotation of logfiles will
38 # happen after that time. 0 disables.
39 -#log_rotation_size = 10MB # Automatic rotation of logfiles will
40 +log_rotation_size = 0 # Automatic rotation of logfiles will
41 # happen after that much log output.
44 # These are relevant when logging to syslog:
45 -#syslog_facility = 'LOCAL0'
46 -#syslog_ident = 'postgres'
47 -#syslog_sequence_numbers = on
48 +syslog_facility = 'LOCAL0'
49 +syslog_ident = 'postgresql-9.6'
50 +syslog_sequence_numbers = on
51 #syslog_split_messages = on
53 # This is only relevant when logging to eventlog (win32):
55 #debug_print_plan = off
56 #debug_pretty_print = on
57 #log_checkpoints = off
58 -#log_connections = off
59 -#log_disconnections = off
61 +log_disconnections = on
63 #log_error_verbosity = default # terse, default, or verbose messages
65 -#log_line_prefix = '' # special values:
66 +log_line_prefix = '%m [%p] %q%h/%a %u/%d ' # special values:
67 # %a = application name