Support for Postgres SSL Mode variable

[sschneider-3as]

When running an external PostgreSQL server with SSL enabled ( e.g. in Azure ), the connection string used in Studio cannot be constructed in a way to add the sslmode option. Connections will fail, saying

Error: no pg_hba.conf entry for host "x.x.x.x", user "xxx", database "xxx", no encryption

Suggesting to add an environment variable POSTGRES_SSL_MODE to enable sslmode

[CasperKristiansson]

This is already supported, but the setting belongs to postgres-meta, not Studio. Add it to the meta service:

services:
  meta:
    environment:
      PG_META_DB_SSL_MODE: require

Then recreate that service with docker compose up -d --force-recreate meta.

The current official Compose image (supabase/postgres-meta:v0.96.6) reads this variable and adds sslmode=require to the connection URL; I also verified that behavior in the released container. If you set PG_META_DB_URL yourself, that full URL takes precedence, so add ?sslmode=require there instead.