Manage Azure Database for PostgreSQL flexible server by using the Azure CLI

This article shows you how to manage your Azure Database for PostgreSQL flexible server deployed in Azure. Management tasks include compute and storage scaling, admin password reset, and viewing server details.

Prerequisites

If you don't have an Azure subscription, create a free account before you begin.

You need to run Azure CLI version 2.53 or later locally. It's recommended to run latest released version of CLI. To see the version installed, run the az --version command. If you need to install or upgrade, see Install the Azure CLI.

Sign in to your account by using the az login command.

az login

Select your subscription by using the az account set command. Make a note of the id value from the az login output to use as the value for the subscription argument in the following command. If you have multiple subscriptions, choose the subscription to which the resource should be billed. To identify all your subscriptions, use the az account list command.

az account set --subscription <subscription id>

Important

To follow this how-to guide, you need to create an Azure Database for PostgreSQL flexible server.

Scale compute and storage

Important

To scale the storage or compute, you must have at least READ permission on the owning resource group.

You can easily scale up your compute tier, vCores, and storage by using the following command. For a list of all the server operations you can run, see the az postgres flexible-server overview.

az postgres flexible-server update --resource-group myresourcegroup --name mydemoserver --sku-name Standard_D4ds_v3 --storage-size 6144

The following table describes the arguments in the preceding code:

Setting Sample value Description
name mydemoserver Enter a unique name for your server. The server name can contain only lowercase letters, numbers, and the hyphen (-) character. It must contain 3 to 63 characters.
resource-group myresourcegroup Provide the name of the Azure resource group.
sku-name Standard_D4ds_v3 Enter the name of the compute tier and size. The value follows the convention Standard_{VM size} in shorthand. See the pricing tiers for more information.
storage-size 32768 Enter the storage capacity of the server in megabytes. The minimum storage size is 32768,

Important

You can't scale down storage.

Manage Azure Database for PostgreSQL databases on a server

You can use many applications to connect to your Azure Database for PostgreSQL flexible server. If your client computer has PostgreSQL installed, you can use a local instance of psql. Use the psql command-line tool to connect to the Azure Database for PostgreSQL flexible server.

  1. Run the following psql command:

    psql --host=<servername> --port=<port> --username=<user> --dbname=<dbname>

    For example, the following command connects to the default database called postgres on your Azure Database for PostgreSQL flexible server mydemoserver.postgres.database.azure.com through your access credentials. When you're prompted, enter the <server_admin_password> that you chose.

    psql --host=mydemoserver.postgres.database.azure.com --port=5432 --username=myadmin --dbname=postgres

    After you connect, the psql tool displays a postgres prompt where you can enter SQL commands. A warning appears in the initial connection output if the version of psql you're using is different from the version on the Azure Database for PostgreSQL flexible server.

    Example psql output:

    psql (11.3, server 12.1)
WARNING: psql major version 11, server major version 12.
         Some psql features might not work.
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
Type "help" for help.

postgres=>

    Tip

    If the firewall isn't configured to allow the IP address of your client, the following error occurs:

    "psql: FATAL: no pg_hba.conf entry for host <IP address>, user "myadmin", database "postgres", SSL on FATAL: SSL connection is required. Specify SSL options and retry."

    Confirm your client's IP address is allowed in the firewall rules.

  2. Create a blank database called postgresdb by typing the following command at the prompt:

    CREATE DATABASE postgresdb;

  3. At the prompt, run the following command to switch connections to the newly created database postgresdb:

    \c postgresdb

  4. Type \q and select Enter to quit psql.

In this section, you connected to the Azure Database for PostgreSQL flexible server via psql and created a blank user database.

Reset the admin password

Change the administrator role's password by using the following command:

az postgres flexible-server update --resource-group myresourcegroup --name mydemoserver --admin-password <new-password>

Important

Choose a password that has a minimum of 8 characters and a maximum of 128 characters. The password must contain characters from three of the following categories:

  • English uppercase letters
  • English lowercase letters
  • Numbers
  • Non-alphanumeric characters

Delete a server

To delete the Azure Database for PostgreSQL flexible server, run the az postgres flexible-server delete command.

az postgres flexible-server delete --resource-group myresourcegroup --name mydemoserver

Related content

  • Last updated on