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'
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:
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:
Let us know how it goes!
PostgreSQL is one of the most powerful and popular relational database management systems available for open source platforms. In this guide, we'll talk about how to get it up and running on an Ubuntu 14.04 VPS instance.