connect to droplet running postgresql 9.3 with pgadmin3

Question

Hey Folks. I am running ubuntu 14.04 x64 on my own computer, and I am trying to access a droplet that is running 1404 x64 with postgresql 9.3. So I want to connect to the droplet postgresql instance using pgadmin3. I was not sure how to do this though? Are there any particular permissions or services I have to set on the droplet to remotely connect with pgadmin?

Andrew SB · Answer

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!

Andrew SB · Answer

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

101010kb · Answer

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?

Become a contributor for community

DigitalOcean Documentation

Resources for startups and AI-native businesses

The developer cloud

Start building today

Report this

connect to droplet running postgresql 9.3 with pgadmin3

Report this

connect to droplet running postgresql 9.3 with pgadmin3