pgBadger(PostgreSQL日志分析工具)安装使用

下载地址：
https://github.com/darold/pgbadger/releases

1、安装pgbadger

tar -xvf pgbadger-9.2.tar.gz
cd pgbadger-9.2
perl Makefile.PL
make
make install

2、PostgreSQL配置

修改postgresql.conf文件：

logging_collector = on
log_filename = 'postgresql-%w.log'
log_file_mode = 0640
log_truncate_on_rotation = on
log_rotation_age = 1d
log_min_duration_statement = 0
log_checkpoints = on
log_connections = on
log_disconnections = on
log_duration = on
log_lock_waits = on
log_line_prefix = '%t [%p]: [%l-1] user=%u,db=%d '
log_destination =stderr

3、安装php

yum -y install php

4、测试分析

./pgbench -i
./pgbench -c 10 -t 1000
[itm_pg@docker ~]#pgbadger /home/itm_pg/pgdata/log/*.log -o /tmp/out.html -f stderr