Deploying Azure flexible server hangs

Question

Following this page:

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/tutorial-webapp-server-vnet

When creating the actual database, the process hangs. It eventually fails after a couple hours with this: The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.

I've tried a bunch of variations (ie changing regions, sizes, etc), but no luck. I've also deleted the vnet, subnet and private dnszone that previous tries had created, but that makes no difference either.

I can create a db without a vnet successfully though, but of course using a vnet is a requirement in our case.

Any suggestions? Thanks.

Answer 1

Hi Julian Wood •,

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

Solution:

It turns out the server name and/or the vnet name need to be globally unique. So a command like this worked for us.

az postgres flexible-server create --resource-group occplatforms-liftops-scheduleapp-dev-rg --name occdevtestpostgres --vnet occdevtestvnet --location westus2

If you have any other questions or are still running into more issues, please let me know. Thank you again for your time and patience throughout this issue.

Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.

Thanks

Answer 2

Hi Julian Wood •,

I could not deploy Flexible Server in my subscription in WestUS2, but in EastUS2 I was able to deploy:

Could you please retry in a different region as it might be a transient issue on that day.

If this does not work, please raise support case.

Thanks

Answer 3

It turns out the server name and/or the vnet name need to be globally unique. So a command like this worked for us.

az postgres flexible-server create --resource-group occplatforms-liftops-scheduleapp-dev-rg --name occdevtestpostgres --vnet occdevtestvnet --location westus2