On opening the API Proxy page, I am seeing "Error while fetching object org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Conneciton; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP Connections.)
What should I do to resolve the issue?
Answer by corinna fu · Feb 06, 2015 at 11:22 PM
Apigee uses the Postgres database for storing analytics data. On opening the API proxies page in the management UI, the Apigee management UI would load the API proxy performance data from the Postgres database for the Performance section following the API proxy list. The error indicates that the Apigee management server is not able to contact the Postgres server to retrieve the data.
If the connection is down between the management server and the postgres server, please fix the network issue between the two nodes. If there is no network connection problem, please do 'nc -z <IP of the Postgres server> 5432' from the management server to see if the port is open for access. If the port is not open for access, please go to the Postgres server and check if the postmaster process is running, e.g, ps -elf | grep postmaster and you should see something similar to /usr/pgsql-9.3/bin/postmaster -p 5432 -D /ebs/pgdata. If the postmaster process does not exist, you could try running the <apigee-bin>/all-stop.sh script then the <apigee-bin>all-start.sh script on the Postgres server and see if the postmaster process would start and the error in the management UI would disappear.
There are more links regarding Postgres server setup and could help further diagnose the problem, for example, http://www.postgresql.org/docs/9.0/static/server-start.html and http://stackoverflow.com/questions/20825734/postgresql-connection-refused-check-that-the-hostname-and-port-are-correct-an.
Why does Apigee Edge show no data in Analytics? 1 Answer
Custom Dimension not appearing 1 Answer
How to Start, Stop, and Restart Apigee Edge in a private cloud deployment? 1 Answer
How can we change the Analytics Custom report duration on Private Cloud? 1 Answer
Are stand-by PostgreSQL used for analytics queries? 0 Answers