Azure CLI command to upgrade the performance tier of Azure PostgreSQL Flex Server.

Galla, Narasimha 25

Hi All,

I am currently trying to upgrade PostgreSQL database server with the following CLI command integrated with ADO and facing the issues as mentioned below.

az postgres flexible-server update --subscription="xxxx" --resource-group="xxx" --name xxxx --sku-name Standard_D32ds_v5 --performance-tier P50 --storage-size 1 User's image

But per documentation, --performance-tier seems to be a valid argument.

User's image

Any help to resolve this much appreciated.

Thanks.

Chan Tak Lun 0 Reputation points

2023-12-15T08:21:45.7666667+00:00

Hi Galla, Narasimha

Please also noted that not all Baseline performance tier could be upgraded to P50.

You may find the details from the table here:

https://learn.microsoft.com/en-us/azure/virtual-machines/disks-change-performance

Thanks.

Galla, Narasimha 25

Hi @ShaktiSingh-MSFT ,

Thanks for reverting back, below is simple ADO pipeline that we are using for upgrading. Unfortunately, we don't have permissions to update it directly from Azure Portal.

trigger: none
    
jobs:
  - job: 'AzureCLI'
    displayName: Build Single Task
    pool: 'ADO-XXX-XXX-XXX-XXX'
    steps:
    - task: AzureCLI@2
      inputs:
        azureSubscription: 'ARMSvc-ATXXX-XXXX-XXX-XXX-XXX-XXX'
        scriptType: 'bash'
        scriptLocation: 'inlineScript'
        inlineScript: |
          az config set extension.use_dynamic_install=yes_without_prompt
          az postgres flexible-server update --subscription="xxxx" --resource-group="xxx" --name xxx --sku-name Standard_D32ds_v5 --performance-tier P50 --storage-size 1

Thanks for your feedback.

ShaktiSingh-MSFT 15,301 Reputation points

2023-12-18T10:28:18.0733333+00:00

Hi Galla, Narasimha,

Thanks for the information.

I am checking on this and will get back to you.
ShaktiSingh-MSFT 15,301 Reputation points

2023-12-20T12:51:01.1133333+00:00

Hi Galla, Narasimha,

Thanks for your patience.

I tried to check with the internal team, but they seem to be busy with other deliverables.

I would recommend you to please file a support ticket for analysis and solution, and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you. Thanks

1 answer

ShaktiSingh-MSFT 15,301 Reputation points

2023-12-15T08:08:30.12+00:00

Hi
Galla, Narasimha •,

Welcome to Microsoft Q&A forum.

As I understand, you want to upgrade the performance tier of Azure PostgreSQL Flex Server using Azure CLI.

Could you please let us know how the integration of Azure CLI and ADO is done so that we understand where the command is getting executed?

Also, please note that you can only scale down the Performance Tier of your server 12 hours after scaling up. This restriction is in place to ensure stability and performance after any changes to your server's configuration.

Please share configuration details of your Flexible Server so that we can reproduce the scenario at our end and check the issue.

As a workaround, we suggest you to use Azure portal for updating the server illustrated here:

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-scale-compute-storage-portal#scaling-down

Thanks
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer