`psql` fails to connect to maincloud via PGWire with `sslmode=require`

[dalton-oliveira]

Description

When connecting to a SpacetimeDB Cloud instance (maincloud.spacetimedb.com) using a PostgreSQL client, the connection fails if SSL is enforced, throwing an error indicating that the server does not support SSL. This contradicts the official documentation which states sslmode=require is supported for Cloud deployments.

Reproduction Steps

Attempt to connect to a maincloud database using psql (v17) with SSL explicitly required:

psql-17 "host=maincloud.spacetimedb.com port=5432 user=any dbname=quickstart-chat sslmode=require"
psql-17: error: connection to server at "maincloud.spacetimedb.com" (131.153.201.171), port 5432 failed: server does not support SSL, but SSL was required