PGAdmin unable to connect to APM Database

Document ID : KB000029724
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

What to do when PGAdmin is unable to connect to the APM database and returns the message that the server is not listening.

Solution

PGAdmin is returning the message that the server is not listening. Trying the following does not resolve the issue:

  • Adding 5432 to TESS iptables and doing a services restart.
  • Uncommenting 5432 from postgres.conf, which is listening to all IP addresses.

This is not a problem with CEM, but with a third-party tool. Refer to the links below on "How Do I Enable Remote Access to PostgreSQL database server to troubleshoot the issue?"

The two key steps are:

  • Add a host all line /var/lib/pgsql/data/pg_hba.conf to allow access for the particular subnet.
  • Restarting iptables /etc/init.d/iptables restart.

Links :

http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html

http://stackoverflow.com/questions/18580066/how-to-allow-remote-access-to-postgresql-database

http://www.seapine.com/kb/questions/1621/Enabling+Remote+Connections+on+PostgreSQL+Servers

http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html