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

Pascal Lammers 11 Reputation points
2021-06-25T08:09:09.237+00:00

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 database for PostgreSQL - Security

Azure Logic App - PostgreSQL-Connector
Azure Logic App - PostgreSQL-Connector

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,253 questions
Azure Database for PostgreSQL
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
40,317 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.