Question
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
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×
Hi, were you ever able to get this solved?
I am having the same issue on a Django 1-click install on Ubuntu.
I have the name, user, and password, also trying on port 5432, using the Pycharm IDE’s. I have been able to connect to remote MySQL and SQL-Servers elsewhere in the past using this IDE.