Hi all If I choose a remote PostgresSQL database for Dagster

Question

Hi all If I choose a remote PostgresSQL database for Dagster s logs etc that s accessed over the public internet i e not sitting in a VPC does anyone know if Dagster automatically encrypts the data with TLS during transit I assume it does but I thought I would check Thanks

Noah K · Answer

What does your connection string look like

Noah K · Answer

<https www postgresql org docs current libpq connect html LIBPQ CONNSTRING> goes over the parameters available in libpq sslmode is the important starting one

Noah K · Answer

And that defaults to `prefer`

Noah K · Answer

meaning it will try for an opportunistic upgrade but will accept unencrypted

Noah K · Answer

You would likely want `sslmode=verify full` instead slightly smiling face

Peter B · Answer

oh great thanks so much really appreciate it