How to use azure functions to do import and export of database oprations on a azure postgres?

Question

How to use azure functions to do import and export of database oprations on a azure postgres?

I have azure postgres flexible server VM and having private vnet for it instead of public endpoint.

Same vnet I have aks cluster and it can access the postgres database.

Can I create any azure function to do that export and import or any sql commands to run on postgres flexible private database?

I tried creating azure function app and created private endpoint in the inbound section to that vnet and postgres subnet. But it is not able to do that communication.

Please suggest.

Answer 1

To be able to access resource on your vNet, in this case the Postgres private endpoint, you need to use vNet integration with the function, not inbound private endpoints. Inbound PE will deal with connecting to the function over the vNet, not going from the function to Postgres.

You will need to use vNet Integration to join the function to the vNet, so that it can then talk to the Private Endpoint. This will require you to use either the App Service Plan or Premium version of functions, as the consumption plan does not support this.