connect to droplet running postgresql 9.3 with pgadmin3

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: <br> <br><pre> <br>#listen_addresses = ‘localhost’ <br></pre> <br> <br>to <br> <br><pre> <br>listen_addresses = ‘*’ <br></pre> <br> <br>Then restart postgres with: “service postgresql restart” <br> <br>Now you should be ready to connect using pgadmin3. Take a look at the documentation here: <br> <br>http://www.pgadmin.org/docs/1.18/connect.html <br> <br>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. <br> <br>For some more basic postgres help, check out: <br> <br>https://www.digitalocean.com/community/articles/how-to-install-and-use-postgresql-on-ubuntu-14-04 <br> <br>Let us know how it goes!

@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. <br> <br>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? <br>