Hi How I make SSL connection while connecting to postgres db

Question

Anna Geller · Answer

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

Anna Geller · Answer

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 ```

Amol Shirke · Answer

Yep added that

Amol Shirke · Answer

I found its not prefect but certificate issue now

Amol Shirke · Answer

Thanks