From: | <soumik(dot)bhattacharjee(at)kpn(dot)com> |
---|---|
To: | <sushantxp(at)gmail(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org>, <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | RE: TCP/IP connections refused |
Date: | 2020-10-29 11:39:58 |
Message-ID: | 7d2987e1a37846289f0e514400ca92e6@kpn.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)gmail(dot)com>
Sent: donderdag 29 oktober 2020 11:05
To: Bhattacharjee, Soumik <soumik(dot)bhattacharjee(at)kpn(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org; pgsql-admin(at)lists(dot)postgresql(dot)org
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<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<mailto: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<http://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
From | Date | Subject | |
---|---|---|---|
Next Message | soumik.bhattacharjee | 2020-10-29 11:45:02 | RE: TCP/IP connections refused |
Previous Message | srijith s | 2020-10-29 11:24:10 | Re: Postgres windows binary |