configuring pg admin

July 2, 2013 5k views
m73mitchell
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 https://dl.dropboxusercontent.com/u/10328969/pgadmin.png
Log In to Comment
6 Answers
kamaln7 MOD July 2, 2013
Did you run "./postgresql-tunnel.pl start"?

Name can be anything you want
Host should be 127.0.0.1
Port should be 5433

What you're doing is basically mapping port 5433 on your local machine to port 5432 on the server, therefore you have to connect to localhost:5433.
Reply
m73mitchell July 2, 2013
Hi, I did run "./postgresql-tunnel.pl start" and it asked me for my password for the server, which I entered and the terminal just returned to normal. there was no confirmation that I was connected. I opened PG Admin3 and clicked on the local PGSQL5432, and, within that, I clicked on the name of the production database. That's where I thought something wasn't working right, because I couldn't see any of the data that I would have expected to see if I was looking in my production database.
Reply
kamaln7 MOD July 2, 2013
The fact that you've been able to connect means the tunnel was successfully set up.
Everything seems to be working - is there anything else we can help you with?
Reply
m73mitchell July 2, 2013
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
Reply
kamaln7 MOD July 2, 2013
Make sure the user you're connecting as has proper permissions to read the production database and its tables.
Reply
crosslink06 February 4, 2014
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...

When I do a dokku config app_name, here is what I get:
postgres://root:[PART2]@[PART3]/[DATABASE NAME]

And here is the info that I provide in pgadminIII:
name: droplet name
host: value of PART3 (it's an IP with no port number specified)
port: 5432 (default)
username root
password: value of PART2

Thanks in advance for your help
Reply
Have another answer? Share your knowledge.