TablePlus-Windows
TablePlus-Windows copied to clipboard
Please consider supporting using the system certs to determine if a server's cert is trusted
Currently the only way to use sslmode=verify-full is to either put a copy of the root cert in AppData\Roaming\postgresql\root.crt
or point the "CA Cert" button at it in the connection settings even if my system already trusts the cert. There are a lot of services now that will host databases that present certs that are signed by real CA cert authorities and they can be checked in the same way browsers check the certs of websites. It would be nice if TablePlus could be made to check the cert against the system CAs like how the psql
cli does.
Please answer the questions below, it helps us to track the issue.
- Which driver are you using and version of it (Ex: PostgreSQL 10.0): postgresql 16
- Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 274
- The steps to reproduce this issue: Set the sslmode to verify-full Try to connect to a neon database or any database that presents a cert signed by a trusted CA. Noted: If the bug is related to data, please attach an example SQL data.