Обсуждение: TCP/IP connections refused

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)

5. $ 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

 

6. $ cat /etc/postgresql/12/main/postgresql.conf | grep port

port = 5432                             # (change requires restart)

#ssl_passphrase_command_supports_reload = off

 

 

Thanks

 

Hi,

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)

5. $ 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

 

6. $ cat /etc/postgresql/12/main/postgresql.conf | grep port

port = 5432                             # (change requires restart)

#ssl_passphrase_command_supports_reload = off

 

 

Thanks

 

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.karandikar@gmail.com>
Sent: donderdag 29 oktober 2020 10:33
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>; pgsql-admin@lists.postgresql.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.bhattacharjee@kpn.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)

5. $ 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

 

6. $ cat /etc/postgresql/12/main/postgresql.conf | grep port

port = 5432                             # (change requires restart)

#ssl_passphrase_command_supports_reload = off

 

 

Thanks

 

On the client machine if you have telnet or nc utilities, can u check below?

Hi Siddharth,

 

Yes, java microservice are hosted on separate machine running on kubernetes/docker.

 

I have used command ss -nt dst 10.133.214.30/30 to check whether we are able to connect to the DB server.

State is not established.

 

 

 

From: Siddharth Karandikar <siddharth.karandikar@gmail.com>
Sent: donderdag 29 oktober 2020 11:34
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>; pgsql-admin@lists.postgresql.org
Subject: 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.bhattacharjee@kpn.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.karandikar@gmail.com>
Sent: donderdag 29 oktober 2020 10:33
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>; pgsql-admin@lists.postgresql.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.bhattacharjee@kpn.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)

5. $ 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

 

6. $ cat /etc/postgresql/12/main/postgresql.conf | grep port

port = 5432                             # (change requires restart)

#ssl_passphrase_command_supports_reload = off

 

 

Thanks