First you need to make sure postgres is accessible remotely. Edit the file "/etc/postgresql/9.3/main/postgresql.conf " and change the "listen line from:

#listen_addresses = 'localhost'

to

listen_addresses = '*'

Then restart postgres with: "service postgresql restart"

Now you should be ready to connect using pgadmin3. Take a look at the documentation here:

http://www.pgadmin.org/docs/1.18/connect.html

In the host field, use the IP address of your droplet. By default, postgres listens on port 5432. The username and password should be for the database user.

For some more basic postgres help, check out:

https://www.digitalocean.com/community/articles/how-to-install-and-use-postgresql-on-ubuntu-14-04

Let us know how it goes!

You could use something like:

host    all         all         0.0.0.0/0       md5

to enable connections from all IPs provided you have the password. Though it's generally considered better practice to restrict access to certain IP ranges. You can provide multiple different ranges if you move between different trusted networks. Check out the documentation here:

http://www.postgresql.org/docs/9.3/static/auth-pg-hba-conf.html

@dangelo: Have you set up a firewall? Make sure port 5432 on the server is actually open. On the server, you can run "netstat -plunt" to see a list of which ports are open with something actively listening for connections.

Hmm, I tried this. I opened the postgresql.conf file, uncommented the listen_address option and set it to "*". I then restarted the postgresql 9.3 service.

The issue I am running into is an error message saying that I need to include an entry in the pg_hba.conf file to include my iprange in the connections. pgadmin indicated I needed to include a "local all all 192.168.0.0/24" rule there. However, I am worried about portability as I take my laptop from network to network. Is there any better way to do this?

Hi:

I am trying to use pgAdmin III to access my postgresql database on Ubuntu 14.04 x32. I did the step above to postgresql.conf, but on my client I get the following error:

"could not connect to server: Connection refused Is the server running on host "xxx.xxx.xxx.xx" and accepting TCP/IP connections on port 5432?"

Is there anything else that I could do?

Thanks!

Hmm, it looks like that could be my issue:

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 797/sshd
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 855/postgres
tcp6 0 0 :::22 :::* LISTEN 797/sshd

What would be the best way to open up port 5432 for external connections? (I assume the line 127.0.0.1:5432 opens it locally). Thanks again for your assistance.

@dangelo: It looks like you are actually using port 855 for postgres. So make sure you use that in the pgAdmin III connection dialog.

Even if I use that, I'm still not having success. Do I need to be using SSH tunnelling?

I'm using:
Host: My droplet IP
Port: 855
Maintenance DB: postgres
Username: postgres
Password:

Am I missing something? Thanks again for the help.

@dangelo.cm: Are you getting the same error message when you change the port or something different?

I am getting the same error message. There wouldn't be a firewall set up on the server by default, would there be?