We are trying to access (server1)postgresql port 5432 on a different server(server 2) but we are not able to reach it.
- port 5432 running/listening postgresql.conf
- listening address okay:listen_addresses = '*'
pg_hba.conf also good: host all all 0.0.0.0/0 md5
firewall is also okay since packet trace results shows that server1 has been reached but denied by the server/application/db
- Firewalld is off and allowed tcp on port 5432 in iptables.
Any other suggestions or possible cause why can't we establish the connection?