Thanks Gilberto, yes I did that, but won't this be a security issue? I tried this below in pg_hba.conf , but no help. host all all 0.0.0.0/0 md5 So I think listen_addresess ='*' is the only way out. Thanks.. -----Original Message----- From: gilberto.castillo@xxxxxxxxx <gilberto.castillo@xxxxxxxxx> Sent: maandag 23 december 2019 20:34 To: Bhattacharjee, Soumik <soumik.bhattacharjee@xxxxxxx> Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [MASSMAIL]Cannot connect to postgresql on port 5432 Importance: High Hi You might change postgresl.conf the line listening = '*' El 2019-12-23 14:30, soumik.bhattacharjee@xxxxxxx escribió: > 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
