Re: Cannot connect to postgresql on port 5432

[Pepe TD Vo <pepevo@xxxxxxxxx>]

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 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 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

On Monday, December 23, 2019, 02:30:35 PM EST, <soumik.bhattacharjee@xxxxxxx> wrote:

Hi Experts,

 

Post installation of  PostgreSQL it is not listening on an IP, only on localhost.

 

Please suggest your inputs.

 

 

Used below command for installations –

 

# apt-get install postgresql-12

postgres=# select version();

                                                     version

------------------------------------------------------------------------------------------------------------------

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

(1 row)

 

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

# Database administrative login by Unix domain socket

local   all             postgres                                peer

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only

local   all             all                                     peer

# IPv4 local connections:

host    all             all             127.0.0.1/32            md5

# IPv6 local connections:

host    all             all             ::1/128                 md5

# Allow replication connections from localhost, by a user with the

# replication privilege.

local   replication     all                                     peer

host    replication     all             127.0.0.1/32            md5

host    replication     all             ::1/128                 md5

 

Not connected

 

postgres@srv:/opt$ netstat -nlp | grep 5432

(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 127.0.0.1:5432          0.0.0.0:*               LISTEN      25857/postgres

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

 

 

postgres@srv:~$ telnet 10.133.214.32 5432

Trying 10.133.214.32...

telnet: Unable to connect to remote host: Connection refused