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

Jannick-7987 226 Reputation points
2021-01-30T15:50:29.893+00:00

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:
62135-connection-security.png
This is how I try to connect and the error I get:
62122-logic-apps-designer.png

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

Thanks in advance,
Jannick

Azure SQL Database
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,896 questions
Azure Database for PostgreSQL
0 comments No comments
{count} votes

Accepted answer
  1. Anurag Sharma 17,576 Reputation points
    2021-01-31T16:27:48.863+00:00

    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.


1 additional answer

Sort by: Most helpful
  1. SUNOJ KUMAR YELURU 13,956 Reputation points MVP
    2021-01-31T04:10:23.213+00:00

    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.