Digitalocean Postgresql conenction error after update

2 posts
Constant's profile image Constant posted 11 months ago in General Permalink

Hi Ansgar, After updating to version 12.10.0.7000 I cannot connect to my postgresql DB on digitalocean anymore. I could connect with version 12.08!

The error is:

FATAL: no pg_hba.conf entry for host "x.x.x.x" user "user", database "database", no encryption.

I cannot add this file because I have a Managed PostgreSQL service.

Looking forward to your answer Kind regards Constant

10787 posts
ansgar's profile image ansgar posted 11 months ago Permalink

That error is related to the SSL parameters which I extended for v12.9.

Please try the following:

  • On the SSL tab, check "Use SSL"
  • On the same tab, for "Certificate verification", select "No verification"

This sets sslmode to "require", in contrast to "disable" when the the checkbox is not checked.

Related:

2 posts
Constant's profile image Constant posted 11 months ago Permalink

Thanks Ansgar, worked like a charm, again!

Please login to leave a reply, or register at first.