No direct connection to PostgreSQL server with SSL possible via Logic App

Pascal Lammers 11

We have set up an "Azure Database for PostgreSQL Server" and would like to access it with Logic Apps.
We use the PostgreSQL connector for this.
If "Force SSL connection" is disabled, the connection will also work so that we can read and write data.
However, if we activate "Force SSL connection", the connector can no longer establish a connection to the PostgeSQL database.

Means that an "Inner Azure connection" works without SSL, but not with it.
We don't want to use an on-premise gateway because we only want to use the cloud.

Both the database and the LogicApp are in the same subscription.

I hope you can help me with this problem.

Azure database for PostgreSQL - Security

Azure Logic App - PostgreSQL-Connector

Pramod Valavala 20,516 Reputation points Microsoft Employee

2021-07-06T05:19:26.593+00:00

@Pascal Lammers Apologies for not getting back sooner on this. Looks like this is a limitation. I am checking with the concerned team to gather more insights on this.
Sylvain 216 Reputation points

2021-09-22T13:27:32.837+00:00

Hi, same issue here :)
A workaround is to call a function app which makes the connection.
Dan Chimento 11 Reputation points

2021-10-02T18:41:07.67+00:00

This is a really bad limitation of Logic apps and reduces their value significantly. Can we get an estimate to when this might be resolved?