Report this

What is the reason for this report?

Error When connecting PostgreSQL database in Digital ocean from my local PC

Posted on December 16, 2020

This is what I did to create a Database instance and access it Step 1 : I created my DB instance in digital ocean then I made my IP address as trusted source , got the credentials (host name , db name , user , password) to access it . Step 2 : downloaded postgreSQL to my local PC , opened the psql terminal window , and typed the credentials . Now I get an error .

psql: error: SSL SYSCALL error: Connection reset by peer (0x00002746/10054)
FATAL:  no pg_hba.conf entry for host "123.231.108.177", user "bconic_survey_admin", database "bconic_survey", SSL off

Have I done any mistake upto here ?

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Start building today

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.