Unable to Create Azure Database for PostgreSQL Flexible Server in Germany West Region

Question

Attempting to migrate an Azure Database for PostgreSQL Single Server to a Flexible Server as outlined in the migration tutorial. The first step is to create the new Flexible Server using the same configuration as the existing single server. However, when selecting 'Germany West Central' as the region, the following error occurs: "Subscription XXX is not allowed to provision in 'Germany West Central'." What steps are needed to resolve this issue?

Answer 1

Hi Sarah Langheinrich,

As I understand it, the error message 'Subscription XXX is not allowed to provision in Germany West Central' typically indicates that your subscription does not have the necessary permissions or that the region is currently restricted for new provisions.

Here are a few steps you can take to resolve this issue:

• Ensure that your subscription has the necessary permissions to create resources in the 'Germany West Central' region. Sometimes, certain regions are restricted based on the subscription type or policy settings.
• You may need to request whitelisting for your subscription to provision resources in the 'Germany West Central' region.
• consider using an alternative region that supports Azure Database for PostgreSQL Flexible Server.

Additionally, as you have opened a support ticket, could you please reference the ticket number in your response? This will assist us in tracking the progress of your request and ensuring you receive the most efficient support possible.

I look forward to your reply and greatly appreciate your feedback.

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.

Answer 2

Hi Sarah Langheinrich

Possible Causes:

• Insufficient Permissions: Your subscription might not have the required Azure role-based access control (RBAC) settings to create resources in the specific region.
• Capacity Limits: The region might be experiencing temporary capacity constraints, or your subscription might have reached its limits for that region.
• Azure Policies: Your organization might have policies in place that restrict resource creation in certain regions.

Solution:

Request region enablement for PostgreSQL Flexible Server in Germany West Central via Azure support or choose an alternative region where the service is available.