Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

Hi,
How I make SSL connection while connecting to postgres db?

no expert but some pointers:

The use of SSL can be driven by the `sslmode=value` option on the psql CLI or the <https://www.postgresql.org/docs/14/libpq-connect.html|PGSSLMODE> environment variable

to use it for DB connection for Prefect, I believe you need to add ssl=true to your connection string:

```"&lt;postgresql://x:y@z:5432/psql?ssl=true&gt;"```


I found its not prefect but certificate issue now