The setup includes Aurora PostgreSQL , PMM Server (Docker) and PMM Client (pmm-admin) running on EC2.

Here are the steps.

Prepare the database
Connect from the EC2 machine to Aurora as admin. Get the endpoint from the AWS console →Aurora and RDS

psql –host=<aurora-endpoint> –port=5432 –username=postgres –dbname=postgres

–create monitoring user
CREATE USER pmm WITH ENCRYPTED PASSWORD ‘your_password’;
GRANT rds_superuser TO pmm;
–enable pg_stat_statements extension
CREATE EXTENSION IF NOT EXISTS pg_stat_statements;

Install PMM Client on the EC2 Host
sudo yum install -y https://repo.percona.com/yum/percona-release-latest.noarch.rpm
wget https://downloads.percona.com/downloads/pmm3/3.1.0/binary/redhat/2023/x86_64/pmm-client-3.1.0-7.amzn2023.x86_64.rpm
sudo yum install -y ./pmm-client-3.1.0-7.amzn2023.x86_64.rpm

Register EC2 Host as PMM Client
pmm-admin config –server-insecure-tls –server-url=https://admin:welcome1@localhost

If this fails with

Checking local pmm-agent status…
pmm-agent is running.
Registering pmm-agent on PMM Server…
Failed to register pmm-agent on PMM Server: Post “https://localhost:443/v1/management/nodes”: EOF.

then port 443 must be added for listen to docker. How to add a port in docker(and to test it with curl) is described in Part 1 .But if only listen 443; is added, then curl http… is ok, but curl https… returns “curl: (35) OpenSSL/3.2.2: error:0A0000C6:SSL routines::packet length too long”

This is because we have to add in docker file /etc/nginx/conf.d/pmm.conf not only
listen 443;
but also
listen 443 ssl http2;

Now testing it with ‘curl -k https://localhost:443’  is working (-k to skip certificate validation. EC2 instance’s curl just doesn’t trust the (self-signed) certificate, which is normal for PMM by default)

Then registering the host as PMM client is fine.

Register Aurora PostgreSQL to PMM
pmm-admin add postgresql \
–username=pmm \
–password=’xxxxxxxx’ \
–query-source=pgstatstatements \
–service-name=aurora-postgres \
–host=db-postgres-1-instance-1.cxf8co3va5da.eu-central-1.rds.amazonaws.com \
–port=5432

PostgreSQL Service added.
Service ID : dd2e0625-b47c-4534-9f63-7e345f55bd5f
Service name: aurora-postgres

Verify the Registration
pmm-admin list

You should see the following agent types conencted and running – pmm_agent
node_exporter
postgres_exporter
vmagent

 

View in PMM Web UI
Open: https://<your-ec2-public-ip>

Go to:
Dashboards → PostgreSQL Overview
and you’ll see your Aurora instance metrics.

To avoid costs, do not forget to stop and drop your Aurora DB when you have finished with this hands-on.

Happy clouding!