Error When connecting PostgreSQL database in Digital ocean from my local PC
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 "126.96.36.199", user "bconic_survey_admin", database "bconic_survey", SSL off
Have I done any mistake upto here ?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×