By RhOiYdS
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
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
If you are using firewall don’t forget to allow port 5432 for ufw use :
ufw allow 5432/tcp
I do the samething and works when i change password
sudo -u postgres psql
ALTER USER sammy PASSWORD ‘newpassword’;
@kirilscherbach you’ve provided a much better instruction than the official page of Digital Ocean. The problem is that you haven’t enabled the right url slug etc " How to configure your Postgresql database on Digital ocean" or “How to bla bla bla” and it would have saved me time searching for how to do exactly what you wrote.
You’ve done a fine job writing that article. Hope you change your url slug. ;)
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.