Auto-grow Azure Database for PostgreSQL storage - Single Server using the Azure CLI

APPLIES TO: Azure Database for PostgreSQL - Single Server

This article describes how you can configure an Azure Database for PostgreSQL server storage to grow without impacting the workload.

The server reaching the storage limit, is set to read-only. If storage auto grow is enabled then for servers with less than 100 GB provisioned storage, the provisioned storage size is increased by 5 GB as soon as the free storage is below the greater of 1 GB or 10% of the provisioned storage. For servers with more than 100 GB of provisioned storage, the provisioned storage size is increased by 5% when the free storage space is below 10GB of the provisioned storage size. Maximum storage limits as specified here apply.

Prerequisites

  • This article requires version 2.0 or later of the Azure CLI. If using Azure Cloud Shell, the latest version is already installed.

Enable PostgreSQL server storage auto-grow

Enable server auto-grow storage on an existing server with the following command:

az postgres server update --name mydemoserver --resource-group myresourcegroup --auto-grow Enabled

Enable server auto-grow storage while creating a new server with the following command:

az postgres server create --resource-group myresourcegroup --name mydemoserver  --auto-grow Enabled --location westus --admin-user myadmin --admin-password <server_admin_password> --sku-name GP_Gen5_2 --version 9.6

Next steps

Learn about how to create alerts on metrics.