plugs&＃61;&＃96;echo -e "Text-CSV_XS-1.39\npgbadger-10.3"&＃96;;
baseDir&＃61;&＃96;pwd&＃96;;
for plug in ${plugs};
do tar zxf ${plug}.*; cd ${baseDir}/${plug}; perl Makefile.PL && make && make install; cd ${baseDir};
done;

# 指定csv格式日志
log_destination &＃61; &＃39;csvlog&＃39;
logging_collector &＃61; on
log_directory &＃61; &＃39;pg_log&＃39;
log_filename &＃61; &＃39;postgresql-%w.log&＃39;
log_file_mode &＃61; 0640
log_truncate_on_rotation &＃61; off
log_rotation_age &＃61; 1d
log_line_prefix &＃61; &＃39;%t [%r]-[%p]: %l user&＃61;%u,db&＃61;%d&＃39;
log_lock_waits &＃61; off
log_checkpoints &＃61; off
log_connections &＃61; off
log_disconnections &＃61; off
log_duration &＃61; off
log_min_duration_statement &＃61; 0

# 初始化pgbenth依赖表
pgbench -U postgres -d postgres -i -s 5
# 5客户端压力10秒
pgbench -U postgres -d postgres -v -c 5 -T 10

# 开启httpd服务
systemctl start httpd.service
# 创建日志输出目录
mkdir -p /var/www/html/pgbadger/;
# 查找一下pgbadger命令所在目录
which pgbadger
# 指定命令路径 -> 指定日志路径(名称根据log_filename参数来的) -> 指定httpd的服务为输出目录: 增量生成日志
/usr/local/bin/pgbadger -I -q /data/pgdata/pg_log/postgresql-*.csv -O /var/www/html/pgbadger/

# /etc/cron.d目录下创建文件 pgbadger_cron 并添加如下内容
# 凌晨2点补全目录
0 2 * * * root /usr/bin/mkdir -p /var/www/html/pgbadger/
# 凌晨2点10分分析前天统计日志
10 2 * * * root /usr/local/bin/pgbadger -I -q /data/pgdata/pg_log/postgresql-&＃96;date -d "now -1 days" "&＃43;%w"&＃96;.csv -O /var/www/html/pgbadger/
# 重启crond
systemctl restart crond.service