Hi, currently, libpq does SSL cerificate validation only against the defined `PGSSLROOTCERT` file.
Is there any specific reason, why the system truststore ( at least under unixoid systems) is not considered for the validation? We would like to contribute a patch to allow certificate validation against the system truststore. Are there any opinions against it? A little bit background for this: Internally we sign the certificates for our systems with our own CA. The CA root certificates and revocation lists are distributed via puppet and/or packages on all of our internal systems. Validating the certificate against this CA requires to either override the PGSSLROOTCERT location via the environment or provide a copy of the file for each user that connects with libpq or libpq-like connectors. We would like to simplify this. -- Thomas Berger PostgreSQL DBA Database Operations 1&1 Telecommunication SE | Ernst-Frey-Straße 10 | 76135 Karlsruhe | Germany
