cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Connecting PostgreSQL to Automate

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!! 

 

 

 
1 ACCEPTED SOLUTION

Accepted Solutions
a-ovbord
Community Support
Community Support

Hi @Anonymous,

 

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

View solution in original post

1 REPLY 1
a-ovbord
Community Support
Community Support

Hi @Anonymous,

 

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,738)