Source Postgres: Disable ssl_mode allow and prefer in CDC mode

[edgao]

from https://github.com/airbytehq/oncall/issues/687

2022-09-27 12:27:45 source > The 'database.sslmode' value 'allow' is invalid: Value must be one of disable, verify-ca, require, verify-full

At a minimum, we should error during check. Ideally, we'd show those values conditionally (requires https://github.com/airbytehq/airbyte-internal-issues/issues/813).

Unhappy medium would be to move ssl_mode into the replication_method oneof, but that involves a pretty messy upgrade path.

[bleonard]

check command can make sure (if CDC is chosen), the ssl modes fit with the debezium docs
https://debezium.io/documentation/reference/stable/connectors/postgresql.html#postgresql-property-database-sslmode

Triple check for cloud that we enforce ssl.