From: soumik.bhattacharjee@kpn.com
To: siddharth.karandikar@gmail.com
Cc: pgsql-admin@postgresql.org
Cc: pgsql-admin@lists.postgresql.org
Subject: RE: TCP/IP connections refused
Date: Thu, 29 Oct 2020 10:19:16 +0000
Message-ID: <8e2edc2542e140b8bbd804cdfb269515@kpn.com> (raw)
In-Reply-To: <CAC6xauNWWj=fyrMtUCraZprjc62No32iECB-Bf2nE5kTaLh2Mg@mail.gmail.com>
References: <36b20ed42da4410d9ddd1b1bd0140d41@kpn.com>
<CAC6xauNWWj=fyrMtUCraZprjc62No32iECB-Bf2nE5kTaLh2Mg@mail.gmail.com>
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<mailto: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)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: soumik.bhattacharjee@kpn.com, siddharth.karandikar@gmail.com, pgsql-admin@lists.postgresql.org
Subject: RE: TCP/IP connections refused
In-Reply-To: <8e2edc2542e140b8bbd804cdfb269515@kpn.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox