Azure Database for postgresql with basic tier is not allowed with ARM template

Sumit Kumar 101 Reputation points
2021-07-07T13:50:44.167+00:00

112622-02postgresqlazurejson.txtI am trying to create a ARM for postgresql single server. But continuously getting below error 

{"code":"DeploymentFailed","message":"At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/DeployOperations for usage details.","details":[{"code":"InvalidEditionSloCombination","message":"The edition Basic does not support the service objective GP_Gen5_2"}]}

Is basic tier is not supported by ARM templates.

I have attached my template files.

112643-02postgresqlazureparametersjson.txt

Azure Database for PostgreSQL
0 comments
Accepted answer
  1. Sumit Kumar 101 Reputation points
    2021-07-09T03:05:40.11+00:00

    Hi,

    You are right. The sku name should be B_Gen5_2. There is a rule for sku naming.

    Sku Name: the SKU tier prefix, SKU family, and SKU capacity, joined by underscores, such as B_Gen5_1, GP_Gen5_2 (the default), or MO_Gen5_32.

    https://video2.skills-academy.com/en-us/azure/postgresql/quickstart-create-postgresql-server-database-using-arm-template?tabs=azure-portal

    113173-screenshot-20210709-083110.png

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 19,101 Reputation points Microsoft Employee
    2021-07-07T19:31:35.66+00:00

    Hi @Sumit Kumar Thank you for posting your question on Microsoft Q&A.
    This is because you are using 'GP_Gen5_2'. It needs to be 'Basic_Gen5_2'. It's conflicting

    If the answer helped please accept as answer so it will be beneficial for other community members facing the same issue.

    Regards,
    Oury

    1 person found this answer helpful.

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.