How to Monitor Managed PostgreSQL with PMM 1-Click App

Last verified 30 Jul 2026

PostgreSQL is an open source, object-relational database built for extensibility, data integrity, and speed. Its concurrency support makes it fully ACID-compliant, and it supports dynamic loading and catalog-driven operations to let users customize its data types, functions, and more.

Percona Monitoring and Management (PMM) is an open source database observability tool. You can run PMM on a DigitalOcean Droplet using the PMM Marketplace 1-Click App, then connect your managed database clusters so PMM can collect metrics and query analytics.

Deploy the 1-Click App, then install the PMM Integration helper on the Droplet and use its web UI to register DigitalOcean Managed PostgreSQL clusters. For PMM features and setup outside this helper flow, see the PMM documentation.

Warning

Third-party tools can change. Confirm compatibility with your database version and PMM release before production use.

The helper supports Managed PostgreSQL Standard Edition clusters. It does not support PostgreSQL Advanced Edition.

Prerequisites

  • A DigitalOcean account with at least one Managed PostgreSQL Standard Edition cluster.
  • A personal access token with the scopes database:read, database:create, and database:view_credentials. Creating the pmm_monitor user requires database:create and database:view_credentials.

Deploy the PMM 1-Click App

  1. Create a Percona Monitoring and Management Droplet or follow the Control Panel and API steps on the PMM catalog page.
  2. Open the PMM web interface at https://your_droplet_public_ipv4/ and sign in with the default credentials (admin / admin). Change the admin password when prompted.
  3. Copy the Droplet public IPv4 address. You use it to add the Droplet to the cluster’s trusted sources in the next section.

Add the PMM Droplet to Trusted Sources

PMM connects to each managed database over the public network by default. Before you register clusters, add the PMM Droplet as a trusted source on every cluster you plan to monitor.

If the Droplet IP is missing from trusted sources, the helper cannot reach the database and registration fails.

Install the PMM Integration Helper

SSH into the PMM Droplet as root using the SSH key you selected when you created the Droplet:

ssh root@your_droplet_public_ipv4

Install the helper. You do not need sudo because the session is already root:

curl -sSL https://raw.githubusercontent.com/pagombin-do/pmm-integration/main/install.sh | sh

The installer clones the app into /opt/pmm-integration, creates a Python virtual environment, generates a self-signed TLS certificate, opens TCP port 8443 in ufw when ufw is active, and starts the pmm-integration systemd service. The installer is idempotent, so you can re-run it to update the helper.

If you use a DigitalOcean Cloud Firewall on the Droplet, add an inbound rule for TCP port 8443. The installer does not create Cloud Firewall rules.

Register Clusters in the Helper UI

Open the helper in your browser:

https://your_droplet_public_ipv4:8443/

Your browser shows a certificate warning because the TLS certificate is self-signed. Accept the warning to continue.

Complete the following steps in the UI:

  1. Enter your DigitalOcean API token and PMM admin password. The helper validates both before continuing. Credentials stay in browser memory for the session and are never written to disk on the Droplet.
  2. Select the PostgreSQL engine. Optionally enable the private (VPC) endpoint if the Droplet and database are in the same VPC.
  3. Select one or more online Managed PostgreSQL clusters. Clusters that are not online are unavailable. Clusters already registered with PMM show a Remove option.
  4. Create a pmm_monitor database user automatically through the DigitalOcean API, or enter existing monitoring-user credentials manually. If pmm_monitor already exists or you skip auto-create, create or retrieve the credentials in the Control Panel or API, then return to the helper, or add the instance manually in the PMM UI.
  5. Confirm integration. The helper registers each selected cluster with PMM.

Complete PostgreSQL Privileges for Query Analytics

For Managed PostgreSQL, creating pmm_monitor is not enough for Query Analytics (QAN). After the helper creates the user (or after you create the user yourself), connect as doadmin and grant the monitoring privileges described in Configure a PMM Monitoring User.

Database metrics and QAN work after you grant those privileges. However, Managed PostgreSQL does not allow superuser access or host agents such as node_exporter, so PMM Node Summary metrics stay empty.

Verify Monitoring

In the PMM UI, confirm that the selected services appear and begin reporting metrics. For PMM dashboards and query analytics workflows, see the PMM documentation.

We can't find any results for your search.

Try using different keywords or simplifying your search terms.