Azure Postgresql Flexible Server with Vnet integration

Question

Hi

We have created a Azure Postgresql Flexible server with VNET integration. When we are trying to connect to it from the pgadmin installed on local machine, it is giving connection issue. We have checked and found network issues.

In one of the MS article it is mentioned that if the server is vnet connected you can only access it from the resources within that same vnet. Is it true?

If yes, this is very big limitation. Also then how Azure pipelines will connect to it for scripts deployments etc.

Please let us know.

Thanks

Answer 1

@Abhay Gupta Thank you for posting your question on Microsoft Q&A and for using Azure services.

In my understanding, you are not able to connect to your PostgreSQL from pgadmin installed on your local machine because of some network issues but looks like it is related to some networking issues.
If you want to connect to the flexible server from a client that is provisioned in another VNET, you have to link the private DNS zone with the VNET. See this linking the virtual network documentation on how to do it. Please let me know if that is not the ask here.
how Azure pipelines will connect to it for scripts deployments etc.
You can automatically deploy your database updates to Azure Database for PostgreSQL Flexible Server after every successful build with Azure Pipelines.