Postgres connections should support verify-ca and verify-full SSL modes

[iainsproat]

Prerequisites

• I read the contribution guidelines
• I checked the documentation and found no answer.
• I checked existing issues and found no similar issue.
• I checked the community forum for related discussions and found no answer.
• I'm requesting the feature to the correct repository (see also speckle-server, speckle-sharp, specklepy, speckle-docs, and others)

What package are you referring to?

All server packages connecting to postgres database (via knex module)

Is your feature request related to a problem? Please describe.

In instances where the postgres database is not in the local network, or other situations where higher security/trust is required, Postgres provides verify-ca and verify-full SSL modes for connections.

Describe the solution you'd like

Speckle server should provide a means for configuring the additional TLS certificates required for verify-ca and verify-full SSL modes.

Describe alternatives you've considered

Additional context

node-postgres documentation: https://node-postgres.com/features/ssl

Related issues or community discussions