This PR updates the existing PostgreSQL docs for connecting to an external database to include instructions for configuring an SSL connection. It also provides commands by which one may generate one's own self-signed certificate authority to sign server/client certificates. This also provides a convenient mechanism by which to test https://github.com/sagemathinc/cocalc/pull/7274. Note that at the time of writing, the cocalc-docker image does not yet include the changes necessary for encrypted database connections, and so you will need to build your own image (and update the relevant docker run commands to use this image) to test this out until those changes are released.
This PR updates the existing PostgreSQL docs for connecting to an external database to include instructions for configuring an SSL connection. It also provides commands by which one may generate one's own self-signed certificate authority to sign server/client certificates. This also provides a convenient mechanism by which to test https://github.com/sagemathinc/cocalc/pull/7274. Note that at the time of writing, the
cocalc-dockerimage does not yet include the changes necessary for encrypted database connections, and so you will need to build your own image (and update the relevantdocker runcommands to use this image) to test this out until those changes are released.Completes #220.