Connecting PostgreSQL to Automate

[credgirl99]

Hi, 

I am trying to connect a PostgreSQL server to Power Automate but am struggling to do so. I keep getting the following error "Please install Npgsql version 4.0.10.0 or earlier" which I did but it is still not working. My PostgreSQL is connected to an AmazonRDS Cloud Server. I am not sure how to connect my PostgreSQL to Automate. Any help would be appreciated. Thanks in advance!! 

[a-ovbord · Accepted solution]

Hi @credgirl99,

Here is the documentation on this one: https://docs.microsoft.com/en-us/connectors/postgresql/ 

So to connect to a PostgreSQL db you'd first need to setup a gateway for the connection.

Then use the PostgreSQL connector to connect to the db through this gateway.

Let me know if this helps.

Thank you,

Ovidiu