I can connect with SSL in PGAdmin to my remote server, but it requires specifying the filepaths for certificate files due to my having different certs for different servers.

However, when connecting from QGIS, I cannot find the option to specify the certificates to use to connect to my remote host. So naturally, when I try connecting and require SSL I get

SSL error: certificate verify failed


After failing to find information online through searching, I decided to click on the HELP button in the PostGIS connection window. Here's what I saw.


After editing the file names to the required ones, the connection was a success. But the case of someone connection to multiple databases with... multiple certificates cannot be so rare.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.