I am trying to connect the postgres Database on Remote Server but I am failed to do so . I have tried every single solution nothing worked out.
this is the problem i am facing
I have tried following steps
Configuration of pg_hba.conf
host all all 127.0.0.1/32 md5 host all all 0.0.0.0/32 md5
postgressql.conf
listen_addresses = '*'
-
sudo service postgresql restart
Defining the inbound rules for port 5432 incase firewall block but I have already off the firewall
5) turn off the firewall
- telnet <host_IP> <port_number>
I got unable to connect with host IP
- psql -h hostip -U dbuser -d dbname
when i use the above line i was successfully connected with ssh putty
but I am failed to connect from PG Admin
- Any help would be appreciated
the database default port is 5432 on the server i have checked twice and its working fine on that
Server Configuration
Postgres installed version is 9.4.
Server operating system : Centos 7
Pgadmin 4 on windows