The PostgreSQL check allows you to monitor PostgreSQL database services. You can verify that the database server is accepting connections, or optionally to login and run a query, and verify that the query results match or are within user-defined limits. The check works with or without SSL and certificate verification can be disabled for self-signed certificates.
If you choose to verify query results, the check connects to the Postgres service and makes a user-defined database query. It then verifies the results of the query with user-defined fields. The results can be either numeric or strings.
For numeric query results, the Postgres check will verify that the number is within the user-defined minimum and maximum range. If the result is outside that range, the check will fail and notifications will be sent.
For string query results, the PostgreSQL check will try an exact match against the user-defined 'match' field. The 'match' field also support regular expressions (regex) matching.
NodePing's PostgreSQL checks can be used to test the availability of a PostgreSQL database service. It can also be used to verify the results of a query. It is often required to whitelist connections from our probes in the service firewall for the monitoring to function. A list of our probe IPs can be found in the FAQ.
If your PostgreSQL service requires authentication please remember that by providing a username/password to someone that is not you, you are creating a new risk. This decision should be weighed very carefully. Please keep our Terms of Service in mind when you are configuring your Postgres checks. It is best practice when you are creating a user for pg monitoring that you have a separate user for monitoring that is restricted to read-only as discussed in the PostgreSQL documentation.
To set up a PostgreSQL check,
To monitor availability of PostgreSQL database services.
IPv6 URLs require the bracket formatting such as postgresql://[2606:c700:4020:11::53:4a3b]/mydb
SSLv3/TLS1.0 are not supported.