配置PostgreSQL日志输出至Linux系统日志文件

最新推荐文章于 2025-05-27 00:08:08 发布

原创最新推荐文章于 2025-05-27 00:08:08 发布 · 704 阅读

5 ·

CC 4.0 BY-SA版权

文章标签：

#postgresql #linux

1.postgresql配置文件修改

1.1 定位PostgreSQL配置位置

导航至PostgreSQL的数据目录，通常位于：

../pgsql/data/postgresql.conf

1.2 调整配置设定

在配置文件中，将日志输出目标更改为同时包含stderr和syslog：
修改前：

#log_destination = 'stderr'  # Valid values are combinations of
     # stderr, csvlog, syslog, and eventlog,
     # depending on platform.  csvlog
     # requires logging_collector to be on.

修改后：

log_destination = 'stderr, syslog'  # Valid values are combinations of
     # stderr, csvlog, syslog, and eventlog,
     # depending on platform.  csvlog
     # requires logging_collector to be on.

1.3.重启数据库服务

完成配置修改后，务必重启PostgreSQL服务以便新设置生效。

2.Liunx系统日志配置调整

2.1 查找rsyslog配置文件

定位至系统日志配置文件路径：

/etc/rsyslog.conf

2.2 调整日志规则

为PostgreSQL相关日志添加特定过滤规则：
修改前：

#### RULES ####

# Log all kernel messages to the console.
# Logging much else clutters up the screen.
#kern.*                                                 /dev/console

# Log anything (except mail) of level info or higher.
# Don't log private authentication messages!
*.info;mail.none;authpriv.none;cron.none                /var/log/messages

# The authpriv file has restricted access.
authpriv.*                                              /var/log/secure

修改后：

#### RULES ####

# Log all kernel messages to the console.
# Logging much else clutters up the screen.
#kern.*                                                 /dev/console

# Log anything (except mail) of level info or higher.
# Don't log private authentication messages!
*.info;mail.none;authpriv.none;cron.none                
if $programname contains 'postgres' then {
   if $msg contains 'postgres system log' then {
      /var/log/messages
   }
} else {
   /var/log/messages
}

# The authpriv file has restricted access.
authpriv.*                                              /var/log/secure