How can I troubleshoot the issue when attempting to add a PostgreSQL Database server, but encountering a failure with an error message prompt?
While attempting to add a PostgreSQL database monitor, if you encounter any errors, please follow the steps below based on the specific error received:
Host not valid. Kindly check the host name given
or
PostgreSQL production server is down
or
The host could not be reached. Check whether you are able to connect to the host with the details given
Issue: The errors occur when Applications Manager is unable to connect to the PostgreSQL server. This could be due to a hostname resolution issue or a firewall restriction.
Solutions:
- Check Network Connectivity
- Open command prompt on the Applications Manager installed server.
- Attempt to ping the PostgreSQL server using the following command:
ping <postgresql_hostnme> - Verify if there is a successful response indicating network connectivity.
- Hostname Lookup
- In the command prompt, verify if the hostname of the PostgreSQL server can be looked up using following command:
nslookup <postgresql_hostname> - Ensure that the hostname can be resolved to an IP address.
- Check Firewall Settings
- Verify if there are any firewall restrictions blocking the connection to the PostgreSQL server.
- Ensure that the necessary ports (e.g., default port 5432 for PostgreSQL) are not blocked by the firewall.
Could not add the PostgreSQL server. Check whether the server is running on the specified
host: postgresql_hostnme and port: 5432.
Kindly check your firewall configurations and user credentials.
host: postgresql_hostnme and port: 5432.
Kindly check your firewall configurations and user credentials.
Issue: The error happens when Applications Manager can't connect to the PostgreSQL server port. This might be because of a wrong port setting, firewall restrictions preventing access, or not having permission to connect to the PostgreSQL port from the Applications Manager server.
Solutions:
- Check Port Connectivity
- Open a command prompt on the Applications Manager installed server.
- Test port access to the PostgreSQL server by running the following command:
telnet <postgresql_hostnme> <port> - Monitor the command response to see if a blank screen appears, indicating successful port connectivity.
- If you receive an error like "Could not open connection to the host, on port 5432: Connect failed", you need to verify the PostgreSQL port / network connectivity
Access denied for remote servers.Change configurations in pg_hba.conf and postgresql.conf file
or
Authentication failed.Kindly verify the configurations in your pg_hba.conf file and the user credentials given.
or
Connection to the PostgreSQL server unsuccessful as password authentication failed for user.
Issue: The error occurs due to restrictions in the PostgreSQL Configuration (pg_hba.conf and postgresql.conf files) preventing remote access to the PostgreSQL server from Applications Manager.
Solutions:
- Open a command prompt on the Applications Manager installed server and navigate to the "AppManager\working\pgsql\bin" directory in the command prompt.
- Execute the following command:psql --host=<postgresql_hostname> --port=<port> --username=<username> <dbname>For example:psql --host=192.168.100.101 --port=5432 --username=postgres postgres
- Based on the response or error message received from the above command, verify the username and password credentials if necessary. Then, take appropriate steps to further diagnose and resolve the issue before making changes to the pg_hba.conf and postgresql.conf files to ensure that the remote access issue is effectively resolved.
- If the issue persists even after attempting the above steps, kindly share the output of the above command with the error message to appmanager-support@manageengine.com to analyze this further.
New to ADSelfService Plus?
Related Articles
How to fix "Communication link failure The last packet sent successfully to the server"?
Issue: Communication link failure error message will trigger based on many reasons. Solution: Communication link failure error message is shown due to various reasons. Follow any of the steps mentioned below to resolve the issue: Insufficient user ...Error message while performing database backup of Applications Manager
While performing a database backup operation of Applications Manager build with Pgsql backend, you may encounter the following error, especially when your database size has grown bigger with a large number of tables. pg_dump: WARNING: out of shared ...Troubleshooting Applications Manager Plugin database migration failure after service pack upgrade of OPM and APM plugin
When upgrading OpManager from version 12.6.xxx to 12.7.xxx and updating the APM Plugin to 1651x, particularly when using Postgresql as the backend database, an essential one-time migration occurs. This migration involves moving our backend Postgresql ...Troubleshooting Bad Request and Internal Server error
Bad Request & Internal Server error When the server of URL cannot understand the request it has received it responds with a Bad request or a malformed syntax error message. If there is an error in processing the request received by the server, it ...How to perform migration to fix "ID out of allocated range" issue or unable to add managed server into admin server due to "server id does not match" error in Applications Manager
If the id value used internally for the monitors crosses the server id value specified in Settings -> Support -> Installation Information -> Server Id - Managed server, then you will get the following alert in Admin server: For existing Managed ...