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

    • I can only see a limited amount of MySQL database monitors added. How to add new databases for monitoring?

      By default, MySQL instances will be auto-discovered and added as free monitors. MySQL data collection and monitoring will start once the agent is provided with the proper credentials. Check this article on how to add or update credentials. New ...

    • My MySQL monitor shows "no data."

      Troubleshooting tips when no data is shown in MySQL monitor: Please provide the credentials to the Site24x7 server monitoring agent using the following command: sudo /opt/site24x7/monagent/scripts/AgentManager.sh mysql --add_instance Ensure the ...

    • I am unable to see any data for failed jobs in my database

      If you are unable to see data for failed jobs or if there is a mismatch between the failed jobs data in the SQL performance monitor and the SQL insight monitor, check if you have granted the necessary permission. Data in the SQL performance monitor: ...

    • 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 ...

    • How is MySQL added for monitoring in Site24x7?

      Site24x7 uses the server monitoring agent to monitor MySQL databases. To install the Site24x7 Server monitoring agent, follow the below steps: Log in to Site24x7. Install the Linux Server monitoring agent by navigating to Server > Server Monitor > ...