Hi Experts,
We are trying to connect from Java(Microservices) applications to Database and getting below issues :
org.postgresql.util.PSQLException: Connection to XXXXXXX:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
Please suggest your inputs and suggestions for solution.
The things I did :
- Firewall/Ports are open from DB server for inbound traffic.
- Added application IP ranges in pg_hba.conf file and restarted the Postgres instance.
- The listen_addresses=’*’ is set to.
- $ lsof -n -u postgres |grep LISTEN
postgres 26802 postgres 3u IPv4 19104770 0t0 TCP *:postgresql (LISTEN)
postgres 26802 postgres 4u IPv6 19104771 0t0 TCP *:postgresql (LISTEN)
- $ netstat -ltnp | grep postgres
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 26802/postgres
tcp6 0 0 :::5432 :::* LISTEN 26802/postgres
- $ cat /etc/postgresql/12/main/postgresql.conf | grep port
port = 5432 # (change requires restart)
#ssl_passphrase_command_supports_reload = off
Thanks
Did you try connecting to it using `psql`? Do you get the same error with that?
On Thu, Oct 29, 2020 at 1:48 PM <soumik.bhattacharjee@xxxxxxx> wrote: