Can't connect to an Azure Database for PostgreSQL server via Azure Logic App

Question

Hi everyone,

I am having trouble connecting to my Azure Postgres database via an Azure Logic App.
When connecting from my PC everything works fine !

For testing purposes I've configured the database as seen here:

This is how I try to connect and the error I get:

Does anyone have an idea? I am really stuck here...

Thanks in advance,
Jannick

Answer 1

Hi @Jannick-7987 , welcome to Microsoft Q&A forum.

As per the screenshot, you are trying to use the SQL connector to connect to Azure PostgreSQL. The issue here is currently there is no connector or trigger available to connect Azure logic apps with Azure Database for PostgreSQL. The connector which is available for PostgreSQL can only connect with on-premise version of PostgreSQL.

You can refer to stack thread for more details where it provides a way to connect Azure PostgreSQL through Azure function and call it from Azure Logic App. Article mentions couple of alternatives for the same.
https://stackoverflow.com/questions/55870598/how-can-i-use-a-azure-database-for-postgresql-in-a-azure-logic-app

You can also upvote the feature on the user voice:
https://feedback.azure.com/forums/287593-logic-apps/suggestions/36672061-add-trigger-and-connector-for-azure-postgre-sql

----------

If answer helps, please mark it 'Accept Answer' as it could help other community members having similar queries.

Answer 2

Hi @Jannick-7987

Please check if it could help at your side:
Automate workflows for a SQL database by using Azure Logic Apps

Steps to resolve persistent connectivity issues

If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.