pgadmin4 connection timed out when connecting with remote database

1.4k Views Asked by At

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 enter image description here

I have tried following steps

  1. Configuration of pg_hba.conf

    host    all             all             127.0.0.1/32             md5
    host    all             all             0.0.0.0/32            md5
    
  2. postgressql.conf

         listen_addresses = '*'  
    
  3.      sudo service postgresql restart
    
  4. Defining the inbound rules for port 5432 incase firewall block but I have already off the firewall

5) turn off the firewall

  1. telnet <host_IP> <port_number>

I got unable to connect with host IP

  1. 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 
0

There are 0 best solutions below