# Postgresql service with sslmode SSL off

**URL:** <https://community.dreamfactory.com/t/postgresql-service-with-sslmode-ssl-off/5039>\
**Category:** Authentication & Security\
**Created:** [October 2, 2019, 7:15am UTC](https://community.dreamfactory.com/t/postgresql-service-with-sslmode-ssl-off/5039 "2019-10-02T07:15:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![PhantomSalt](https://avatars.discourse-cdn.com/v4/letter/p/278dde/32.png) [@PhantomSalt](https://community.dreamfactory.com/u/PhantomSalt)\
**Post date:** [October 2, 2019, 7:15am UTC](https://community.dreamfactory.com/t/postgresql-service-with-sslmode-ssl-off/5039/1 "2019-10-02T07:15:24Z")

</div>

Hi,

I am trying to connect a postgresql db as a service. I can’t seem to get the sslmode option to work. I have tried adding it as an option and in the connection string.

The error I get is ![image](https://canada1.discourse-cdn.com/flex035/uploads/dreamfactory/original/2X/f/fe6d05222d3e3f8490424a1e2066a088a7049ea3.png)

I have tried ssl and sslmode as the key. I have tried setting the value of sslmode to true, 1, TRUE, require, on and probably a few other things but it doesn’t seem to make any difference.

I found [https://wiki.dreamfactory.com/DreamFactory/Features/Database/PostgreSQL](https://wiki.dreamfactory.com/DreamFactory/Features/Database/PostgreSQL) which states it should be a boolean. Has anyone done this that can give me some guidance?

Thanks.

---

<div class="post-metadata">

**Author:** ![NolsSmit](https://avatars.discourse-cdn.com/v4/letter/n/9de053/32.png) [@NolsSmit](https://community.dreamfactory.com/u/NolsSmit)\
**Post date:** [June 29, 2021, 9:26am UTC](https://community.dreamfactory.com/t/postgresql-service-with-sslmode-ssl-off/5039/2 "2021-06-29T09:26:39Z")

</div>

I’m also looking for the answer. Maybe it is a dummy feature.