Why is the PostgreSQL individual database monitor shown as down even though that database is up in my instance?

Why is the PostgreSQL individual database monitor shown as down even though that database is up in my instance?

If your PostgreSQL individual database monitor shows as down in Site24x7 but the database is active (up) in your instance, verify that if you have given the necessary permissions for the database user to access that specific database. Refer to our help page for database user creation details.



The following permission is essential for Site24x7 to connect to the database. Grant the necessary Connect permission to the database to continue monitoring:
GRANT CONNECT ON DATABASE <database_name> to site24x7;

Example: 
GRANT CONNECT ON DATABASE postgresqldb1 to site24x7;

Also, ensure that all the prerequisites on our PostgreSQL monitoring help page are met.

If the issue still persists, zip all the agent logs and send the file to support@site24x7.com. 

    • Related Articles

    • How do I monitor an Oracle database hosted in a Docker container in the same machine?

      To monitor your Oracle Database hosted in a Docker container, follow these steps: Log in to Site24x7 and install the Site24x7 Linux monitoring agent. Execute the following command in your terminal and enter your Oracle Database instance's username ...

    • Unable to add SQL insight monitor

      If the SQL Insight monitor is not getting added even after entering your credentials, try these troubleshooting steps: Ensure that the Auto-discover applications feature is enabled. If not, you will need to trigger discovery using the Discover ...

    • Troubleshooting false positive alerts in monitoring

      Problem False positive alerts are being generated. Possible cause The monitoring system is down in some locations. The Website monitor might be configured for one location, such as Seattle, but may appear down when accessed from another location, ...

    • Amendments to Site24x7 Monitor Names

      We've recently renamed a few of our Monitors to help keep in sync with the current IT and DevOps trends. The new monitor names are designed to correctly resonate with the IT & DevOps crowd. We've made necessary changes in the Web client, Help ...

    • How does Site24x7 always ensure the availability of its location agents during monitoring?

      Site24x7 uses a preferred location recheck logic in the back-end to ensure the availability of all monitoring locations. This logic is only applied when you've disabled the option "Restrict monitoring within selected locations" in the Add or Edit ...