Availability zone became unavailable, how can I switch?

Question

We deployed an Azure Database for PostgreSQL flexible server several months ago. A few weeks ago we started getting these messages during automated deployments:

Availability zone '1' is not available for subscription '{subscriptionId}' in this region temporarily due to capacity constraints.

Apparently Azure removed the combination on location and availability zone. Is there a way to switch the availability zone for an existing database? I didn't find a way to do so in the azure portal.

Answer 1

Have you tried disabling HA and reenabling it?

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-manage-high-availability-portal#disable-high-availability

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin

Answer 2

Hi Sven,

Sometimes it is possible to have capacity constraints in some availability zones in certain regions.

1. In case the HA is not enabled - it is not possible to change the Availability zone for example Zone 1 to Zone 2. 

2. One of the ways you can achieve this is by enabling the HA. You can follow the steps below; 



	Step 1: Enable HA 

	Step 2: Select preferred Standby availability zone 

	Step 3: Wait for enable HA operation to complete. 

	Step 4: Perform failover

	Step 5: Wait for failover to complete 

	Step 6: Ensure the Primary availability zone is switched to your preferred availability zone. 

	Step 7: Disable HA. 

Refer this document : https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-manage-high-availability-portal