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

• How to retain specific settings for an individual subscription monitor that is under a management group monitor

  When you have multiple subscriptions under a management group, all the customization settings that are applied to the management group (parent) monitor will be applied to all the subscription monitors that come under that management group by default, ...

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