Support for client certificate authentication in PostgreSQL connectors #189
Description
Is your feature request related to a problem? Please describe.
Add support for mutual TLS authentication parameters in pw.io.postgres.write, dict to enable client certificate-based authentication.
Describe the solution you'd like
The parameters to implement are:
- sslcert - path to the client certificate file
- sslkey - path to the client private key file
- sslpassword - password for decrypting the private key (if encrypted)
These parameters follow the standard libpq connection parameter specification and should work analogously to other PostgreSQL drivers and clients.
They must be parsed from postgres_settings parameter.
Describe alternatives you've considered
The connector currently supports:
sslmode(all six standard modes)sslrootcert(server certificate validation)
So the implementation is not an absolute urgency, still the current set is not enough.
Additional context