Support of custom CAs to deal with self-signed certificates

exyi / pg2parquet

Export PostgreSQL table or query into Parquet file

Apache License 2.0

57 stars 11 forks source link

Closed moritz93 closed 3 months ago

moritz93 commented 3 months ago

If the PG server uses a self-signed certificate, sslmode=require is not supported. It would be nice to have an option to pass a custom root CA (https://docs.rs/openssl/0.9.24/openssl/ssl/struct.SslContextBuilder.html#method.set_ca_file).

exyi commented 3 months ago

Hi! I have added the option in #21, could you please verify that it works for you? You can run the development version using the following commands:

git clone https://github.com/exyi/pg2parquet.git
cd pg2parquet/cli
git switch ssl-root-cert
cargo run -- export {your options}

moritz93 commented 3 months ago

Works, thanks a lot!

exyi commented 3 months ago

Thanks a lot for testing it for me :) I have release it as the 0.1.0 version.