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
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.