Postgres 17 server certificate is issued by RapidSsl for server.mydomain.com This is validated by DigiCert Global Root G2 certificate.
PostgreSQL 17 client certificate is created using this tutorial.
pg_hba.conf first lines contain:
hostssl all varukoopia ::/0 cert hostssl all varukoopia 0.0.0.0/0 cert Trying to use it on Windows Server:
set PGSSLCERT=client.crt set PGSSLKEY=client.key set PGSSLROOTCERT=system "c:\Program Files\PostgreSQL\17\bin\pg_dump" --verbose -b -f "test.backup" -F c -h server.mydomain.com -p 5432 -U varukoopia mydatabase Throws this error:
pg_dump: error: connection to server at "server.mydomain.com" (x.x.x.x), port 5432 failed: SSL error: unregistered scheme
postgres log file contains message
[unknown] [unknown]@[unknown] LOG: could not accept SSL connection: tlsv1 alert unknown ca
How to use the client certificate with pg_dump?
According to https://github.com/EnterpriseDB/edb-installers/issues/264
Windows system certificate store is not supported. How to specify root certificates or disable issuer certificate verification?
