Remote access to PostgreSQL with pgAdmin
I can’t access remotely to a PostgreSQL, with pgAdmin database installed on an Ubuntu 16.04 droplet, with the Wordpress one install.
I would like to import a dump file, with the database settings from my local computer.
In the postgresql.conf file I have set:
listen_addresses = ’*’
Running SHOW listen_addresses; I get localhost (1 row)
and in the pg_hba.conf one:
host all all 0.0.0.0/0 md5
But each time, that I try to connect from pgAdmin at my local computer I get this message:
could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host “220.127.116.11” and accepting TCP/IP connections on port 5432?
Any help would be much appreciated.
Thanks in advance,