PostgreSQL 日志功能设置

日志文件

PostgreSQL有3种日志，分别是：

pg_log（数据库运行日志）

pg_xlog（WAL 日志，即重做日志）

pg_clog（事务提交日志，记录的是事务的元数据）

设置文件postgresql.conf中日志功能及释义

# - Where to Log -
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 = 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,can be absolute or relative to PGDATA
log_filename = 'postgresql-%a.log'     # log file name pattern,can include strftime() escapes
#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 = 0                  # Automatic rotation of logfiles will happen after that much log output.0 disables.
log_truncate_on_rotation = on          # If on, an existing log file with the same name as the new log file will be truncated rather than appended                                         # to.But such truncation only occurs on time-driven rotation, not on restarts or size-driven rotation.
                                       # Default is off, meaning append to existing files in all cases.

# These are relevant when logging to syslog:
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'
#syslog_sequence_numbers = on
#syslog_split_messages = on

# This is only relevant when logging to eventlog (Windows):
# (change requires restart)
#event_source = 'PostgreSQL'

# - When to Log -
log_min_messages = warning        # values in order of decreasing detail:
                                  #   debug5
                                  #   debug4
                                  #   debug3
                                  #   debug2
                                  #   debug1
                                  #   info
                                  #   notice
                                  #   warning
                                  #   error
                                  #   log
                                  #   fatal
                                  #   panic

log_min_error_statement = error    # values in order of decreasing detail:
                                   #   debug5
                                   #   debug4
                                   #   debug3
                                   #   debug2
                                   #   debug1
                                   #   info
                                   #   notice
                                   #   warning
                                   #   error
                                   #   log
                                   #   fatal
                                   #   panic (effectively off)

log_min_duration_statement = -1    # -1 is disabled, 0 logs all statements
                                   # and their durations, > 0 logs only
                                   # statements running at least this number
                                   # of milliseconds

#log_min_duration_sample = -1      # -1 is disabled, 0 logs a sample of statements
                                   # and their durations, > 0 logs only a sample of
                                   # statements running at least this number
                                   # of milliseconds;
                                   # sample fraction is determined by log_statement_sample_rate

#log_statement_sample_rate = 1.0   # fraction of logged statements exceeding
                                   # log_min_duration_sample to be logged;
                                   # 1.0 logs all such statements, 0.0 never logs

#log_transaction_sample_rate = 0.0      # fraction of transactions whose statements
                                        # are logged regardless of their duration; 1.0 logs all
                                        # statements from all transactions, 0.0 never logs

#log_startup_progress_interval = 10s    # Time between progress updates for
                                        # long-running startup operations.
                                        # 0 disables the feature, > 0 indicates
                                        # the interval in milliseconds.

# - What to Log -
#debug_print_parse = off
#debug_print_rewritten = off
#debug_print_plan = off
#debug_pretty_print = on
#log_autovacuum_min_duration = 10min    # log autovacuum activity;
                                        # -1 disables, 0 logs all actions and
                                        # their durations, > 0 logs only
                                        # actions running at least this number
                                        # of milliseconds.
#log_checkpoints = on
log_connections = off
log_disconnections = off
#log_duration = off
#log_error_verbosity = default        # terse, default, or verbose messages
#log_hostname = off
log_line_prefix = '%m [%p] '          # special values:
                                      #   %a = application name
                                      #   %u = user name
                                      #   %d = database name
                                      #   %r = remote host and port
                                      #   %h = remote host
                                      #   %b = backend type
                                      #   %p = process ID
                                      #   %P = process ID of parallel group leader
                                      #   %t = timestamp without milliseconds
                                      #   %m = timestamp with milliseconds
                                      #   %n = timestamp with milliseconds (as a Unix epoch)
                                      #   %Q = query ID (0 if none or not computed)
                                      #   %i = command tag
                                      #   %e = SQL state
                                      #   %c = session ID
                                      #   %l = session line number
                                      #   %s = session start timestamp
                                      #   %v = virtual transaction ID
                                      #   %x = transaction ID (0 if none)
                                      #   %q = stop here in non-session processes
                                      #   %% = '%'
                                      # e.g. '<%u%%%d> '
#log_lock_waits = off                 # log lock waits >= deadlock_timeout
#log_recovery_conflict_waits = off    # log standby recovery conflict wait >= deadlock_timeout
#log_parameter_max_length = -1        # when logging statements, limit logged bind-parameter values to N bytes;
                                      # -1 means print in full, 0 disables
#log_parameter_max_length_on_error = 0    # when logging an error, limit logged bind-parameter values to N bytes;
                                          # -1 means print in full, 0 disables
#log_statement = 'none'                   # none, ddl, mod, all
#log_replication_commands = off
#log_temp_files = -1            # log temporary files equal or larger than the specified size in kilobytes;
                                # -1 disables, 0 logs all temp files
log_timezone = 'America/Los_Angeles'