Postgresql - 监控 moniter — pgbadger

pgBadger is a PostgreSQL log analyzer built for speed with fully detailed reports from your PostgreSQL log file. It's a single and small Perl script that outperform any other PostgreSQL log analyzer.

--摘自官网

官网：

http://dalibo.github.io/pgbadger/

pgbadger是一个pg不错的监控，通过对日志的分析，生成html，展示到网页。下面我们来看如何搭建使用。

1. 配置数据库配置参数文件：（具体每个参数的作用参照《配置文件参数解析》）

vim postgresql.conf

log_destination = 'stderr'

logging_collector = on

log_directory = 'pg_log'

log_truncate_on_rotation = on

log_duration = off

log_line_prefix = '%t [%p]: [%l-1] user=%u,db=%d %h'

log_checkpoints = on

log_connections = on

log_disconnections = on

log_lock_waits = on

log_temp_files = 0

log_filename = 'postgresql-%Y-%m-%d-%H.log'

log_min_duration_statement = 0

log_autovacuum_min_duration = 0

lc_messages = 'C'

2. 下载pgBadger，并解压

wget https://github.com/dalibo/pgbadger/archive/v9.2.tar.gz

tar -zxvf v9.2.tar.gz

3. 安装(optional)

cd pgbadger-9.2/

perl Makefile.PL

make && make install

3.执行

 touch /tmp/pg_error.html

pgbadger --prefix='%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h' -f /usr/local/pgsql/data/pg_log/*.log -o /tmp/pg_error.html

============================================================

以后会发一个自动生成增量的脚本

============================================================