postgresql配置错误日志

postgresql数据库的错误日志默认是打开的，如果需要开启或关闭则需要在postgresql.conf文件中进行配置。

通常情况下postgresql.conf位于程序安装的根目录下，以Mac操作系统为例，对应的配置文件路径为：

/Library/PostgreSQL/9.6/data/postgresql.conf

在该配置文件中，日志采集默认配置如下：

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 = 'pg_log'    # 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,can include strftime() escapes

#log_file_mode = 0600                   # 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
                                        # 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.
#log_rotation_age = 1d                  # Automatic rotation of logfiles will
                                        # happen after that time.  0 disables.
#log_rotation_size = 10MB               # Automatic rotation of logfiles will
                                        # happen after that much log output.
                                        # 0 disables.

通过以上配置可以指定日志的输出格式，日志的输出文件等信息。

postgresql配置错误日志插图