psql could not connect to server connection refused error when connecting to ¬†using -'postgresql,ubuntu,psql,centos7'
I am trying to connect to a postgres database installed in a remote server using the following command:
psql -h host_ip -U db_username -d db_name
This the error that occurs:
¬†¬†psql: could not connect to server: Connection refused
¬†¬†¬†¬†¬†¬†Is the server running on host "" and accepting
¬†¬†¬†¬†¬†¬†TCP/IP connections on port 5432?
Postgres installed version is 9.4.
Host operating system : Ubuntu 15.04
Client operating system : Centos 7
I already tried the following but the issue remains unresolved:
Edited pg_hba.conf file to include
¬†¬†host ¬†¬†¬†all ¬†¬†¬†¬†all ¬†¬†¬†¬†0.0.0.0/0 ¬†md5
Edited 'postgresql.conf' and changed the listen parameter to
Restarted postgres service.
Disabled firewall and iptables on host and client.
I checked by running the psql command locally and it worked.
I tried the second solution given in this question. Running nmap gave me the following output:
Starting Nmap 6.47 ( http://nmap.org
) at 2015-09-07 18:08 IST
Nmap scan report for 10.17.250.250
Host is up (0.0000040s latency).
Not shown: 997 closed ports
PORT ¬†¬†STATE SERVICE
22/tcp open ¬†ssh
25/tcp open ¬†smtp
80/tcp open ¬†http
Am I missing something. Hope someone can help.