pmm監(jiān)控postgresql數(shù)據(jù)庫

pmm監(jiān)控postgresql數(shù)據(jù)庫詳細信息請參考：
Configuring PostgreSQL for Monitoring：
https://www.percona.com/doc/percona-monitoring-and-management/conf-postgres.html

pmm安裝部署請參考：
https://blog.51cto.com/1937519/2319421

以下步驟為安裝和配置pmm client需要在被監(jiān)控的postgresql數(shù)據(jù)庫服務(wù)上面操作：
1.安裝pmm client：

rpm -ivh https://www.percona.com/redir/downloads/percona-release/redhat/latest/percona-release-0.1-6.noarch.rpm
yum install pmm-client -y

2.設(shè)置數(shù)據(jù)庫，創(chuàng)建用戶：
ALTER SYSTEM SET track_io_timing=ON;
SELECT pg_reload_conf();
CREATE USER pmm_user WITH SUPERUSER ENCRYPTED PASSWORD 'secret';

3.配置監(jiān)控服務(wù)器
pmm-admin config --server 192.168.56.200 --server-user admin --server-password admin
或者：
pmm-admin config --server 192.168.56.200

4.添加操作系統(tǒng)監(jiān)控：
pmm-admin add linux:metrics

5.添加postgresql數(shù)據(jù)庫監(jiān)控：
pmm-admin add  postgresql --host=localhost --password='secret' --port=5432 --user=pmm_user

6.登錄監(jiān)控查看：