question

SumitKumar-4017 avatar image
0 Votes"
SumitKumar-4017 asked SumitKumar-4017 answered

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

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-postgresql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SumitKumar-4017 avatar image
0 Votes"
SumitKumar-4017 answered

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://docs.microsoft.com/en-us/azure/postgresql/quickstart-create-postgresql-server-database-using-arm-template?tabs=azure-portal

113173-screenshot-20210709-083110.png



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OuryBa-MSFT avatar image
1 Vote"
OuryBa-MSFT answered OuryBa-MSFT commented

Hi @SumitKumar-4017 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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SumitKumar-4017 I have not heard back from you. Did the answer resolve the issue? If so , please mark as accept answer , if not please let me know how I may better assist you.
Regards,
Oury

0 Votes 0 ·