Postgres Flexible server fails to deploy

jw 1 Reputation point
2023-07-19T12:43:48.7766667+00:00

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'

Azure Database for PostgreSQL
{count} votes

2 answers

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 29,517 Reputation points Microsoft Employee
    2023-07-19T14:52:46.6033333+00:00

    @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

    User's image

    Regards

    Geetha

    0 comments No comments

  2. RahulRandive 10,221 Reputation points
    2023-07-19T19:50:27.4766667+00:00

    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!


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.