PostgreSQL Monitor

The PostgreSQL monitor in updu provides deep connection level metrics and validates that a PostgreSQL RDBMS server is accessible, authenticating, and accepting connections properly.

Configuration Options

updu supports two distinct parsing strategies for Postgres connection properties. You can either utilize a unified driver connection string (DSN URL), or declare individual connection parameters manually.

Basic Settings

• Name: A descriptive name for your monitor.
• Group: Optional group assignment for organizing monitors.
• Interval (seconds): How frequently updu should perform the check.
• Timeout (seconds): The maximum time updu will wait for a response reading before considering the check failed.

PostgreSQL Specific Settings

• Connection String (DSN): A full URL connection string combining the necessary parameters, optionally leaving the rest blank. Formatting follows standard logic, for example: postgres://username:password@localhost:5432/database_name. Updu will establish TCP connections to this destination.

Fallback Individual Settings

• Hostname: The IP address or domain name of the postgres server. (e.g. localhost).
• Port: The connection port the server exposes (standard is 5432).
• User/Password: Authentication details mapped to the requested instance.
• Database: The specific database catalog name to query.
• SSL Mode: Allows fine-tuning the sslmode query parameter, including disable, require, verify-ca, and verify-full.

Example Use Cases

• Postgres Outages: Ensure critical web applications utilizing a remote SQL RDBMS don't abruptly crash or lock up without emitting alerts.