Postgres Flexible server fails to deploy

Question

I try to create a new Postgres Flexible server from the Azure Portal web ui.
I use Postgres 11, with private network access, however it fails to deploy.

Start time: 7/19/2023, 12:01:18 PM UTC

Correlation ID: 67ae5778-33ff-4926-9c7f-0ca2ef06d5d2

The Status code is Conflict, with the following error message:

The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'

Answer 1

Hi @jw

Thanks for your question.

Based on Correlation ID you have shared, the deployment seems failed due to

The subnet with name ['GatewaySubnet'] in virtual network ['es-vnet'] is not allowed to host a Postgres flexible server. Please choose another subnet.

Reference document on Networking overview- https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-networking

Hope this helps!

Let us know if you have any concern of need additional information.

Thank you!

Answer 2

@jw Thanks for providing additional information

I just tried deploying Postgres flex 11 with Public and Private region West Europ and I did not face any issues.I was able to deploy it successfully

As an alternative can you try deploying using CLI and let me know if you are still facing the same issue

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-manage-virtual-network-cli

Regards

Geetha