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

本文主要是介绍配置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