Support client authentication for postgres

[wangxiaoying]

Thanks for replying so quickly. My use case really revolves around the way our database is secured. Typically a client will request access and certificates are issued through a Vault. So in my case I only have 3 certs and no password is issued.

Originally posted by @frostpuppet in https://github.com/sfu-db/connector-x/issues/104#issuecomment-1023812217

[wangxiaoying]

Hi @frostpuppet, sorry for the late response. We have added the support for client authentication in our newest version 0.2.5. To set up the certs and keys, you need to add the url params like this "?sslmode=require&sslrootcert={postgres_rootcert}&sslcert={postgres_sslcert}&sslkey={postgres_sslkey}". Can you try to see whether it works?

[frostpuppet]

sorry for the delay. let me get it tried out.