Use secure authentication for TimescaleDB

[steven-sheehy]

Problem
The default authentication for PostgreSQL is the insecure md5. Since our TimescaleDB is new we have a chance to improve the security of our database authentication without causing breaking changes.

Solution
Use a secure form of authentication like SCRAM-SHA-256 password authentication or if we're using TLS anyway we can utilize certificate authentication.

Alternatives

Additional Context