search

antares-sql / antares

A modern, fast and productivity driven SQL client with a focus in UX
https://antares-sql.app
MIT License
1.87k stars 129 forks source link

Postgres No Encryption Error #893

Open jreaci opened 1 week ago

jreaci commented 1 week ago

Describe the bug I'm getting a "error: no pg_hba.conf entry for host...no encryption" error when attempting to connect. I'm able to connect to dBeaver without providing certificate files and using the same connection string. A possible solution is using "Untrusted connection", but what does that mean as far as with security? I'm also able, in other environments, to use the sslmode=require parameter with success but that is not working in the connection string either.

Expected behavior A simple connection to a PostgreSQL database.

Application App version 0.7.22 OS name: Windows 11 DB name PostgreSQL

Fabio286 commented 1 week ago

Hi @jreaci ,

Please update to latest Antares version because this issue should be fixed.

jreaci commented 1 week ago

I just tried the Microsoft Store and Portable exe version of 7.29 and I'm getting the same error.

Fabio286 commented 1 week ago

Ok you are right, I was remembering wrong. In earlier versions I added support for ssl=true, but not for sslmode=require. I will work to implement better connection string support.