Re: TCP/IP connections refused

Hi,

You might have already checked but I would suggest checking that the IP
address in pg_hba.conf file is the same client IP for which you have
received the error. For eg. when the error is *Connection to
192.168.42.123:5432 <http://192.168.42.123:5432> refused. * I would add
192.168.42.123 in pg_hba file. This can be your application gateway which
may differ from the actual application server IP.

Please check if Postgres is accepting a connection on port 5432. It may
happen that postgresql.auto.conf may have a different port specified in it.
You can cross verify entries in the postmaster.pid file for listen_address
and port number on which Postgres instance is accepting the connection.

Regards
Sushant

On Thu, Oct 29, 2020 at 1:48 PM <soumik(dot)bhattacharjee(at)kpn(dot)com> wrote:

> 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 :
>
>
>
> 1. Firewall/Ports are open from DB server for inbound traffic.
> 2. Added application IP ranges in *pg_hba.conf* file and restarted the
> Postgres instance.
> 3. The *listen_addresses*=’*’ is set to.
> 4. *$ 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)
>
> 1. *$ 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
>
>
>
> 1. *$ cat /etc/postgresql/12/main/postgresql.conf | grep port*
>
> port = 5432 # (change requires restart)
>
> #ssl_passphrase_command_supports_reload = off
>
>
>
>
>
> *Thanks*
>
>
>