Postgres ssl connection fails

Ask us anything
1

I am a new user trying to connect SQL plugin in my sample app to PostgreSQL db hosted on Digital Ocean. They require the connection to be ssl. My TablePlus sql client on OSX can connect fine but while setting SQL plugin in WeWeb, it fails saying “no pg_hba.conf entry for host “3.88.218.63”, user “doadmin”, database “defaultdb”, no encryption”. Is SSL not supported? How to debug this issue?

2

Hi @navjeetc :wave:

At the moment, you can only connect MSSQL DBs with SSL but @Damien on our team just made a fix that should mean you can do it too with your PostgreSQL DB.

We expect it’ll be in production next week :slight_smile:

Would that work for you?

3

Yeah that will be cool

4

Any update on enabling connecting to postgresql using ssl?

5

Good timing! This was pushed in production this morning :grinning:

Can you check and let us know if it works for you?

6

It works :slight_smile: Thanks for your awesome support.

7

Awesome!

Thank YOU for your patience :slight_smile: