Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support sslrootcert=system in the connection string #1175

Open
contrun opened this issue Oct 13, 2024 · 0 comments
Open

Support sslrootcert=system in the connection string #1175

contrun opened this issue Oct 13, 2024 · 0 comments

Comments

@contrun
Copy link

contrun commented Oct 13, 2024

There is a special value for sslrootcert system introduced in postgresql 16.

https://www.postgresql.org/docs/17/libpq-connect.html

The special value system may be specified instead, in which case the system's trusted CA roots will be loaded. The exact locations of these root certificates differ by SSL implementation and platform. For OpenSSL in particular, the locations may be further modified by the SSL_CERT_DIR and SSL_CERT_FILE environment variables.

This will make ssl connection to the postgresql server much less painful.

@contrun contrun changed the title Support ssllrootcert=system in the connection string Support sslrootcert=system in the connection string Oct 13, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant