日志文件分析工具pgbadger安装篇

系统环境

centos7.4+pg11.6

下载地址

https://github.com/darold/pgbadger/releases

安装

[root@lineqi opt]# tar -xvf v11.3.tar.gz
[root@lineqi pgbadger-11.3]# pwd
/opt/pgbadger-11.3
[root@lineqi pgbadger-11.3]# perl Makefile.PL
Checking if your kit is complete…
Looks good
Writing Makefile for pgBadger
Writing MYMETA.yml and MYMETA.json
[root@lineqi pgbadger-11.3]# make && sudo make install
[root@lineqi pgbadger-11.3]# pgbadger -V
pgBadger version 11.3

postgresql参数配置

log_min_duration_statement = 0
log_line_prefix = '%t [%p]: user=%u,db=%d,app=%a,client=%h ’
log_checkpoints = on
log_connections = on
log_disconnections = on
log_lock_waits = on
log_temp_files = 0
log_autovacuum_min_duration = 0
log_error_verbosity = default
lc_messages = ‘en_US.utf8’
lc_messages=‘C’

生成日志报告

安装httpd服务
[root@lineqi ~]# yum install httpd
生成日志报告
[root@lineqi ~]# pgbadger -I -q -f /data/pg11.6/log/postgresql-2020-08-16* -O /var/www/html/
查看内容
[root@lineqi html]# ls -l /var/www/html/
total 684
drwxr-xr-x 4 root root 31 Aug 16 22:03 2020
-rw-r–r-- 1 root root 695699 Aug 16 22:03 index.html
-rw-r–r-- 1 root root 141 Aug 16 22:03 LAST_PARSED

访问日志报告

启动httpd服务
[root@lineqi html]# systemctl start httpd

点击16号进入如下界面

遇到的问题

[root@lineqi ~]# pgbadger -I -q /data/pg11.6/log/postgresql-2020-08-16* -O /var/www/html/
FATAL: unable to detect log file format from /data/pg11.6/log/postgresql-2020-08-16_215727.log, please use -f option.
- Error at line 16584

参考文档

http://pgbadger.darold.net/documentation.html