PostgreSQL¶

This check confirms login and actual read queries. It reads supported connection, activity, cache and database statistics without changing any data.

Field	Meaning
Database system	MariaDB / MySQL or PostgreSQL
Port	Usually 3306 for MariaDB/MySQL or 5432 for PostgreSQL; the port is adjusted when switching
Database name	Optional for MariaDB/MySQL; required for PostgreSQL, for example `postgres`
Encryption	TLS · validate certificate and server name or No TLS · only on a protected network
User with read access, Password	Database account for the queries
Connection utilization → Warning at (%), Critical at (%)	Defaults: 80 and 95 percent
Replication → Monitor replication	Enables supported replication evaluation
Warning at (seconds), Critical at (seconds)	Replication lag, defaults: 30 and 120 seconds

For PostgreSQL, appropriate statistics permissions, particularly pg_read_all_stats, enable complete activity values. For MariaDB/MySQL, status queries must be permitted and an optionally selected database must be readable. For a custom CA, its certificate must be stored in the monitoring server’s certificate store.