Database monitoring · 10 min read · PostgreSQLdatabase

Monitor PostgreSQL performance and availability

Add a PostgreSQL server as a monitored device using the built-in pg_monitor role.

What you'll need

A Zynty account with Editor or Admin role
Ability to create a dedicated, read-only monitoring user on the database
Network access from the collector to the database's port (default 5432)

Create a monitoring role

PostgreSQL 10+ ships a built-in pg_monitor role that grants exactly the read access needed for monitoring, no need to hand-pick individual privileges.

CREATE ROLE zynty_ro WITH LOGIN PASSWORD 'STRONG_PASSWORD';
GRANT pg_monitor TO zynty_ro;

Allow the connection in pg_hba.conf

Add an entry scoped to your collector's IP, and require an encrypted connection.

hostssl  all  zynty_ro  10.20.0.50/32  scram-sha-256

Reload PostgreSQL

Configuration changes to pg_hba.conf need a reload (not a full restart) to take effect.

SELECT pg_reload_conf();

Add the database in Zynty

Choose PostgreSQL as the type and enter connection details. Enable Require TLS connection to match the encrypted access rule you just configured.

← Previous

Monitor MySQL performance and availability

Track slow queries on MySQL