Shulou(Shulou.com)06/01 Report--

For more information about pmm monitoring postgresql database, please refer to:

Configuring PostgreSQL for Monitoring:

Https://www.percona.com/doc/percona-monitoring-and-management/conf-postgres.html

For pmm installation and deployment, please refer to:

Https://blog.51cto.com/1937519/2319421

The following steps require operation on the monitored postgresql database service to install and configure pmm client:

1. Install 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

two。 Set up the database and create users:

ALTER SYSTEM SET track_io_timing=ON

SELECT pg_reload_conf ()

CREATE USER pmm_user WITH SUPERUSER ENCRYPTED PASSWORD 'secret'

3. Configure the monitoring server

Pmm-admin config-- server 192.168.56.200-- server-user admin-- server-password admin

Or:

Pmm-admin config-server 192.168.56.200

4. Add operating system monitoring:

Pmm-admin add linux:metrics

5. Add postgresql database monitoring:

Pmm-admin add postgresql-host=localhost-password='secret'-port=5432-user=pmm_user

6. Log in to the monitoring to view:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.