Hey!

I recently started developing my droplet, and I’m quite new to this. Im trying to establish a remote PostgreSQL connection through pgAdmin4. The problem is, when I try to connect through pgAdmin4 by going through the Add new server and clicking Save button, it does nothing, sort of freezes.

My droplet is running on Ubuntu 16.04, I followed an instruction on how to set up PostgreSQL on ubuntu 16.04 on Django, installed all the necessary components, set up an environment, and a project, to the point where I even managed to create a db and a table. I even edited the settings.py file:

DATABASES = { ‘default’: { ‘ENGINE’: ‘django.db.backends.postgresql_psycopg2’, ‘NAME’: ‘…’, ‘USER’: ‘…’, ‘PASSWORD’: ‘…’, ‘HOST’: ‘127.0.0.1’, ‘PORT’: ‘5432’, I even added that to the end of the page: STATIC_ROOT = os.path.join(BASE_DIR, ‘static/’)

And, ofcourse changed the ALLOWED HOSTS = [‘…’] to with my droplet ip aswell.

Then I edited both postgresql.conf and pg_hba.conf aswell. The listen_address is set to ’ * ’ and it is uncommented

The pg_hba.conf file:

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 0.0.0.0/0 md5

IPv6 local connections:

host all all ::1/128 md5

I also allowed port 5432 through my firewall.

Any ideas why I can’t set up a connection with pgAdmin?

Thanks