--- postgresql-12.0/src/backend/utils/misc/postgresql.conf.sample 2019-09-30 22:06:55.000000000 +0200 +++ postgresql-12.0/src/backend/utils/misc/postgresql.conf.sample 2019-10-07 21:05:24.551000000 +0200 @@ -416,23 +416,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 = '/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-12.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, # 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 @@ -442,16 +442,16 @@ # or size-driven rotation. Default is # off, meaning append to existing files # in all cases. -#log_rotation_age = 1d # Automatic rotation of logfiles will +log_rotation_age = 0 # Automatic rotation of logfiles will # happen after that time. 0 disables. -#log_rotation_size = 10MB # Automatic rotation of logfiles will +log_rotation_size = 0 # Automatic rotation of logfiles will # happen after that much log output. # 0 disables. # These are relevant when logging to syslog: -#syslog_facility = 'LOCAL0' -#syslog_ident = 'postgres' -#syslog_sequence_numbers = on +syslog_facility = 'LOCAL0' +syslog_ident = 'postgresql-12' +syslog_sequence_numbers = on #syslog_split_messages = on # This is only relevant when logging to eventlog (win32): @@ -504,12 +504,12 @@ #debug_print_plan = off #debug_pretty_print = on #log_checkpoints = off -#log_connections = off -#log_disconnections = off +log_connections = on +log_disconnections = on #log_duration = off #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: # %a = application name # %u = user name # %d = database name