RE: TCP/IP connections refused

[<soumik.bhattacharjee@xxxxxxx>]

Yes Sushant, I added the Apps IP ranges in pg_hba and restarted the PG services.

 

Port is 5432 and also postgresql.auto.conf is having same port.

 

Contents of postmaster.pid

$ cat postmaster.pid

26802

/var/lib/postgresql/12/main

1603903729

5432

/var/run/postgresql

*

  5432001    229378

ready

 

 

 

 

From: Sushant Pawar <sushantxp@xxxxxxxxx>
Sent: donderdag 29 oktober 2020 11:05
To: Bhattacharjee, Soumik <soumik.bhattacharjee@xxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: 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 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.bhattacharjee@xxxxxxx> 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