Connecting to Remote POSTGRESQL Using PgAdmin

Here is how I connect to the PostgreSQL database on a Digital Ocean droplet using pgAdmin III.

Screenshot from 2015-02-17 21:57:05

Screenshot from 2015-02-17 21:55:25

Troubleshooting

Error connecting to the server: fe_sendauth: no password supplied

I got this error after not using pgadmin remotely for a long time. Turns out it was a brain-fart. SSH allows you to connect to the server without a password. But you still need to enter a database password. I did not enter the database password. Maybe that’s why the error message said “no password supplied”. Duh!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s