Remote connect to postgresql with pgadmin
Hi! So i have a test database running on my droplet, but I just cannot remote connect to it. It PGAdmin I have host as my droplet IP, port as 5432, maintenance DB as postgres and username as postgres and password blank, and I get connection refused errors asking me if my server is listening for TCP/IP connections.
I’ve edited the config file to allow ip’s from “*”, and I thought that was all there was to it…
So, am I missing something? Do I need to make additional changes? Or do I need to VPN into digital ocean servers or something?
Any help is appreciated.
Thanks in Advance