Re: TCP/IP connections refused

Soumik, you tested from localhost which is the DB machine itself. And that
is expected to work given the status information you shared in the first
email.

Is your java microservice running on separate machine? on separate network?
Can you connect from that machine/network to postgres server by using any
client (e.g. psql)?

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

> Yes. Its working from my local also.
>
>
>
> *$ psql -h localhost -p 5432*
>
> Password for user postgres:
>
> psql (12.1 (Debian 12.1-1.pgdg100+1))
>
> SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits:
> 256, compression: off)
>
> Type "help" for help.
>
>
>
> postgres=#
>
>
>
> *From:* Siddharth Karandikar <siddharth(dot)karandikar(at)gmail(dot)com>
> *Sent:* donderdag 29 oktober 2020 10:33
> *To:* Bhattacharjee, Soumik <soumik(dot)bhattacharjee(at)kpn(dot)com>
> *Cc:* pgsql-admin <pgsql-admin(at)postgresql(dot)org>;
> pgsql-admin(at)lists(dot)postgresql(dot)org
> *Subject:* Re: TCP/IP connections refused
>
>
>
> 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(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*
>
>
>
>