How to Setup PMM(Percona Monitoring and Management) server and Register PMM client on RHEL based system for PostgreSQL

In this article we will see how to configure PMM (Percona Monitoring and Management) server and PMM Client setup for PostgreSQL.

PMM Architecture
Source: https://www.percona.com/

Prerequisites:

1. We need to have Docker 1.12.6 or higher installed.

PMM Server Installation:

1. Pull the image.

   docker pull percona/pmm-server:2
   

2. Create a persistent data container.

   docker create --volume /srv \
   --name pmm-data \
   percona/pmm-server:2 /bin/true

3. Run the image.

   docker run --detach --restart always \
   --publish 443:443 \
   --volumes-from pmm-data \
   --name pmm-server \
   percona/pmm-server:2

           

Devopszones: Create volume

devopszones: PMM server Install

              3. Connect to Percona Monitoring and Management:

https://<IP Address or hostname of your Percona Monitoring and Management Server>/

Default username/password is admin/admin and should be changed on first login.

Devopszones: PMM Login Page

Install Client

1. Download and install Percona Repo Package

sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

2. Install Percona Monitoring and Management Client

sudo yum install pmm2-client

Devopszones: PMM2 client Install

Devopszones: PMM2 Admin Version

Connect Client to Server

Requirements: Client to server communication to secure port on pmm-server (443 assumed) — must be performed on every system to be monitored.

Register Percona Monitoring and Management client with server

sudo pmm-admin config  --server-insecure-tls  --server-url=https://admin:<password>@<PMM Server IP>

Devopszones: PMM2  client Register

Setup Postgres

Create a Percona Monitoring and Management specific user for Monitoring (using the postgres CLI)

CREATE USER pmm WITH SUPERUSER ENCRYPTED PASSWORD '<password>';

Register the server for monitoring

sudo pmm-admin add postgresql --username='pmm' --password=<password>

Easy-install script

Linux

curl -fsSL -O https://raw.githubusercontent.com/percona/pmm/PMM-2.0/get-pmm.sh -O https://raw.githubusercontent.com/percona/pmm/PMM-2.0/.sha256-oneline && \
sha256sum .sha256-oneline -c && \
chmod +x ./get-pmm.sh && \
./get-pmm.sh

How to Backup and Restore PMM(Percona Monitoring and Management) server Data

How to remove PMM Server