Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ijTYq-0004kH-2F for pgsql-admin@arkaria.postgresql.org; Mon, 23 Dec 2019 19:40:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ijTYo-0007uw-SH for pgsql-admin@arkaria.postgresql.org; Mon, 23 Dec 2019 19:40:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ijTYo-0007uk-FA for pgsql-admin@lists.postgresql.org; Mon, 23 Dec 2019 19:40:10 +0000 Received: from sonic307-2.consmr.mail.bf2.yahoo.com ([74.6.134.41]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ijTYl-0002Xs-81 for pgsql-admin@lists.postgresql.org; Mon, 23 Dec 2019 19:40:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1577130004; bh=sROJbt+ZLnIF3W9q0uFy86x0fXa/erQR7j1C3kx89qw=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=aC1ZzRAdMUwuloxNL4gz7SuU+xZuia4QJBAS4KWAqvAUrpM4UFeSMXaU5lkLLzmrJJzKSxa0YTzrgkKFA1exQLsJ0YWie68NqGtcLkUfv70E4vb4eYjCqN0Rhr6IhoxBKbRoND/QMOYFlRH33iXHcd+w/7FdTzjLf9Rv5gdhPfKb+DCnFUCm62rfqSzQm9I9N/1VKafkpfsr0T4JLJnT4d47L02ag5nmN0HS6naJm5sYJRaSrVaXWIIWIsN5miLA2pFuQfNVIbptlAqSN7lx5wiKBsZ3jPED7ZdXOwB6GpKcRXLkioU7DJELLfl666vYdUu1MK8/NUX3OeTUZaq7Lg== X-YMail-OSG: V_ulx8MVM1krrleGdNfofNMpELXKiwR9H4rxRlT7SC8tBrad76ib3xgxCJ1lCv2 Wwm13D2f87CPdi6HsXe1FrIaX3_iOVGdcVBuDFvbdqtV5qvZINlteSxyHVGbFJAhAAIWUvZpvNBM bqx.24Z.m6ODNohrT32XOOrU1wOkxWKEHzHNDidcichAwXHEke2ePUC7stLfszRWo_FeQ0IZJ91s PSE9aFGFK2hx4JoPpk7kh0u2bBeuAWiLW0ekgoE0jb5FCteSA00WRPi6PBOjkxCtlfMYxwBqKnGZ UqCnpGRJ3ur6wDORdZk3kj_WNvEw3MFY3CDXjyxHBG5kV5Ghns62kjIKQLQAB4dbkHh4aA3Z9TXt _5x7Sz8K7aFaFS.dx9NXRhNh8Ee5NHhvM4edk37VB3EFf_hyLfxSNblG5RUMZQmkgKFtLFhVS6Gk SP0HeoXPN30TMbFc00NB_WC0ZuoIQ0V1.4iDX1zPNiTZpz1TgL1yTQP4_fkX64l_mYJhWqMXuLSZ gcqjSI_gp06gr7mnj5dSWxJx.myuimPhFGkHwSjECcVBvm8Tb6VCoimOJBIHBVVOS8sy0zXUpfKD lrnX9POfHdoj3Jis4ivtPoATCivp4yRy1rgFZDHtRXHgOLICcq8hQoeVsS.uXyjWDcB7N.B9r3g8 kk5UStBvu0Yzr_82bjyrqhH9Ti2i3y05E5S0HgvRw9mHVIENxua.KHLrWW4_HNgQGs7o4Twyoq4N M2ik2wS2YIvUulCG0k3R.5xMTQ0Fq9fC2GyLCJmmC5xTnxLTywFSi8ZRRb2eiuGMA_iW_QdZM7p6 ma.vU_H6ezV7kUJ3DYEFHBIBOrSS2CsbY1.xMnPELw1vldumFqjYNNc9BhtjJT9vbyGIwNQ9pNbQ I72v9ZkXHt3lLYO0RPt4qQp2JntEA1_KrDlUye9v5.zuy39qHMeKkS49OGnrOXb0qSz5nVyUryFM nGPa8lC2P_a3eyZrNuhSGgr4op4Aej5wMQKO62LnpU6U14tDFAALZavkBaeFQ104fWnRUaEB_rJF 3nvV3pF7zEjRH2ui5zyvX.sSh5kg0lBmqcq_z8AuCL6GTToh13Rr1lnL85j4ThQ2VE0gIi8ppD0u 7ZC8n5scVUS3d9KgdaVPgH_.q3hgtiuyWD8reFY1TUafPTx2KC8XjUkun_Cx2A3jfzWNLnBg2.En Bjwg16nCyNykINvAwb.YWy9Lou2uW17LuSfgUnmAghYvv0RkwG03n0ExhDZq4AqHQBA1LrPkCfEI f.95oCK9hgX6RruOSB_9mgSwGUIWNJj2O6qMaLZn71mhGvGIwb_Ysr2FjkUoB7iBaHDOaoy4Mx3p pcT0FrKHI8JzbzPiFbhrYgRP0sR_t.6Er8vABunFntCcdxx4- Received: from sonic.gate.mail.ne1.yahoo.com by sonic307.consmr.mail.bf2.yahoo.com with HTTP; Mon, 23 Dec 2019 19:40:04 +0000 Date: Mon, 23 Dec 2019 19:39:59 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: pgsql-admin@lists.postgresql.org, pgsql-admin@postgresql.org, Message-ID: <1358309851.1890679.1577129999416@mail.yahoo.com> In-Reply-To: <2A91BEF8171A5349931391E0C721CC537D772EF8@CPEMS-KPN501.KPNCNL.LOCAL> References: <2A91BEF8171A5349931391E0C721CC537D772EF8@CPEMS-KPN501.KPNCNL.LOCAL> Subject: Re: Cannot connect to postgresql on port 5432 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1890678_2019893661.1577129999413" X-Mailer: WebService/1.1.14873 YMailNorrin Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36 Content-Length: 17720 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1890678_2019893661.1577129999413 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable change=C2=A0md5 to trust and try to connect again Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love and forgive more.To call= him a dog hardly seems to do him justice though in as much as he had four = legs, a tail, and barked, I admit he was, to all outward appearances. But t= o those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success=20 On Monday, December 23, 2019, 02:30:35 PM EST, wrote: =20 =20 Hi Experts, =20 =C2=A0 =20 Post installation of =C2=A0PostgreSQL it is not listening on an IP, only on= localhost. =20 =C2=A0 =20 Please suggest your inputs. =20 =C2=A0 =20 =C2=A0 =20 Used below command for installations =E2=80=93 =20 =C2=A0 =20 # apt-get install postgresql-12 =20 postgres=3D# select version(); =20 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 version =20 ---------------------------------------------------------------------------= --------------------------------------- =20 PostgreSQL 12.1 (Debian 12.1-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled = by gcc (Debian 8.3.0-6) 8.3.0, 64-bit =20 (1 row) =20 =C2=A0 =20 Entries in ::: /etc/postgresql/12/main/pg_hba.conf =20 # Database administrative login by Unix domain socket =20 local=C2=A0=C2=A0 all=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 postgres=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 peer =20 # TYPE=C2=A0 DATABASE=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 USER=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ADDRESS=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 METHOD =20 # "local" is for Unix domain socket connections only =20 local=C2=A0=C2=A0 all=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 all=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0peer =20 # IPv4 local connections: =20 host=C2=A0=C2=A0=C2=A0 all=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 all=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 127.0.0.1/32=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 md5 =20 # IPv6 local connections: =20 host=C2=A0=C2=A0=C2=A0 all=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 all=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 ::1/128=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 md5 =20 # Allow replication connections from localhost, by a user with the =20 # replication privilege. =20 local=C2=A0=C2=A0 replication=C2=A0=C2=A0=C2=A0=C2=A0 all=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 peer =20 host=C2=A0=C2=A0=C2=A0 replication=C2=A0=C2=A0=C2=A0=C2=A0 all=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 127.0.0.1/32= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 md5 =20 host=C2=A0=C2=A0=C2=A0 replication=C2=A0=C2=A0=C2=A0=C2=A0 all=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ::1/128=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 md5 =20 =C2=A0 =20 Not connected =20 =C2=A0 =20 postgres@srv:/opt$ netstat -nlp | grep 5432 =20 (Not all processes could be identified, non-owned process info =20 will not be shown, you would have to be root to see it all.) =20 tcp=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 0 127.0.0.1:5432=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 = 0.0.0.0:*=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 LISTEN=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 25857/postgres =20 unix=C2=A0 2=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 [ ACC ]=C2=A0=C2=A0=C2=A0=C2=A0 = STREAM=C2=A0=C2=A0=C2=A0=C2=A0 LISTENING=C2=A0=C2=A0=C2=A0=C2=A0 74234=C2= =A0=C2=A0=C2=A0 25857/postgres=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 /var/run= /postgresql/.s.PGSQL.5432 =20 =C2=A0 =20 =C2=A0 =20 postgres@srv:~$ telnet 10.133.214.32 5432 =20 Trying 10.133.214.32... =20 telnet: Unable to connect to remote host: Connection refused =20 =C2=A0 =20 =C2=A0 =20 =C2=A0 =20 ------=_Part_1890678_2019893661.1577129999413 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
change md5 to trust and try = to connect again

Bach-Nga

No one in this= world is pure and perfect.  If you avoid people for their mistakes yo= u will be alone. So judge less, love and forgive more.=
To call him a dog hardly seems to do him justice though in a= s much as he had four legs, a tail, and barked, I admit he was, to all outw= ard appearances. But to those who knew him well, he was a perfect gentleman= (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** = Sharing success


=20
=20
On Monday, December 23, 2019, 02:30:35 PM EST, <sou= mik.bhattacharjee@kpn.com> wrote:


=20 =20

Hi Experts,

=20

 

=20

Post installation of  PostgreSQL i= t is not listening on an IP, only on localhost.

=20

 

=20

Please suggest your inputs.

=20

 

=20

 

=20

Used below c= ommand for installations =E2=80=93

=20

 

= =20

# apt-get insta= ll postgresql-12

=20

postgres=3D# selec= t version();

=20

   =             &nb= sp;            =             &nb= sp;            versi= on

=20

------------------= ---------------------------------------------------------------------------= ---------------------

=20

PostgreSQL 12.1 (D= ebian 12.1-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3= .0-6) 8.3.0, 64-bit

=20

(1 row)

= =20

 

= =20

Entries in := :: /etc/postgresql/12/main/pg_hba.conf

=20

# Database adminis= trative login by Unix domain socket

=20

local   = all            = postgres           =             &nb= sp;        peer

=20

# TYPE  DATAB= ASE        USER    &= nbsp;       ADDRESS    &n= bsp;            METH= OD

=20

# "local" is for U= nix domain socket connections only

=20

local   = all            = all            = ;             &= nbsp;           peer=

=20

# IPv4 local conne= ctions:

=20

host  &n= bsp; all           &= nbsp; all           =   127.0.0.1/32         &n= bsp;  md5

=20

# IPv6 local conne= ctions:

=20

host  &n= bsp; all           &= nbsp; all           =   ::1/128          &= nbsp;      md5

=20

# Allow replicatio= n connections from localhost, by a user with the

=20

# replication priv= ilege.

=20

local   = replication     all      =             &nb= sp;            =       peer

=20

host  &n= bsp; replication     all     &= nbsp;       127.0.0.1/32   &nb= sp;        md5

=20

host  &n= bsp; replication     all     &= nbsp;       ::1/128    &n= bsp;            md5<= /span>

=20

 

= =20

Not connecte= d

=20

 

=20

postgres@srv:/opt$ netstat -nlp | gr= ep 5432

=20

(Not all processes= could be identified, non-owned process info

=20

will not be shown,= you would have to be root to see it all.)

=20

tcp  &nb= sp;     0      0 127.0.0.1:543= 2          0.0.0.0:* &nbs= p;             = LISTEN      25857/postgres

=20

unix  2 =      [ ACC ]     STREAM  =    LISTENING     74234    2585= 7/postgres       /var/run/postgresql/.s.PGSQL= .5432

=20

 

=20

 

=20

postgres@srv:~$= telnet 10.133.214.32 5432

=20

Trying 10.133.214.= 32...

=20

telnet: Unable to = connect to remote host: Connection refused

=20

 

=20

 

=20

 

=20
------=_Part_1890678_2019893661.1577129999413--