In PostgresSQL dont work parammetr "Allow public access from any Azure service within Azure to this server" on china region

Question

Hi,

I am using Azure Database for PostgreSQL in the China region. I also use Azure DevOps for my CI/CD processes. Currently, I am facing an issue where I cannot perform database migrations or execute scripts for the database through Azure Pipelines (in Azure Pipelines, I am using an Azure-hosted Ubuntu 22.04 agent).

This issue arises because the "Allow public access from any Azure service within Azure to this server" setting does not work in the China region. To temporarily resolve the problem, I added an IP range (0.0.0.0 to 255.255.255.255) to the firewall. However, this is not a best practice and makes the database vulnerable.

Could you please clarify why the "Allow public access from any Azure service within Azure to this server" setting does not work in the China region?

Answer 1

Hi Petro Kostiuk (EXT),

Welcome to the Microsoft Q&A and thank you for posting your questions here.

As I understand, you are facing an issue where the ‘Allow public access from any Azure service within Azure to this server’ setting does not work in the China region.

The “Allow public access from any Azure service within Azure to this server” setting doesn’t work in the China region because of different rules and infrastructure managed by 21Vianet. This causes issues with IP ranges and network setups.

For more information, please refer the document: https://learn.microsoft.com/en-us/azure/china/overview-operations.

Use private endpoints or virtual network integration to securely connect your Azure Database for PostgreSQL. This ensures that your database is only accessible within your virtual network.

For more information, please refer the documents:

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-networking-private

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-networking-private-link

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.