By m73mitchell
I have a script (which I copied from a tutorial at linode https://library.linode.com/databases/postgresql/pgadmin-macos-x) that’s supposed to tunnel from my local machine to postgres on my VPS, however, I’m unable to gain access to the database.
I’m not sure if, in the following image,
a) ‘name’ has to be the exact name (case-sensitive) of my droplet b) ‘host’ is my ip address on Digital Ocean, or something else c) if ‘port’ should be 5433 as in the image below, or if I should set it to ‘80’ or something else. Where should I get the port number from
Thanks if you can help
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!
Hi, I would like to connect to the database that I use on my Rails app on Digital Ocean (deployed via dokku) but I can’t… <br> <br>When I do a dokku config app_name, here is what I get: <br>postgres://root:[PART2]@[PART3]/[DATABASE NAME] <br> <br>And here is the info that I provide in pgadminIII: <br>name: droplet name <br>host: value of PART3 (it’s an IP with no port number specified) <br>port: 5432 (default) <br>username root <br>password: value of PART2 <br> <br>Thanks in advance for your help
The fact that you’ve been able to connect means the tunnel was successfully set up. <br>Everything seems to be working - is there anything else we can help you with?
As I said, I can’t see the data I’d expect to see, so I wasn’t sure if the tunnel was connected properly, but if the information provided confirms for you that the tunnel’s set up, then it’s ok i guess. Thanks
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.