I have a PostGIS DB at a remote server and I can connect to it from my desktop using pgAdmin4. However, when I try to connect though QGIS (v3.4) I get an error:
FATAL: no pg_hba.conf entry for host "10.1.<complete ip here>..., user "car_r" database "car", SSL off
The funny thing is that my computer is listed on the server
pg_hba.conf or else I would not be able to connect using pgAdmin4.
Any idea what could be wrong?
Adding more info
My PostGIS server is setup to accept only secure connections (
hostssl in the
pg_hba.conf). When I force QGIS to use SSL, (
SSL mode: require) I get a "SSL error: certificate verify failed" error.
How can I make QGIS recognize my server certificate?