On-demand backups (Preview)

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

This article provides step-by-step instructions to operate with on-demand backups of an Azure Database for PostgreSQL flexible server.

Important

On-demand backups are automatically deleted, according to your configured backup retention period. However, you can manually delete them earlier if they’re no longer needed.

Perform on-demand backups

Portal

Using the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server.

2. In the resource menu, under the Settings section, select Backup and restore.

   

3. Select Backup now.

   

4. In the Take backup pane, the Backup name text box is prefilled with a unique name automatically generated for your backup. Feel free to change that name to any name of your preference.

   

5. Select Trigger.

   

6. A notification informs you that the on-demand backup is initiated.

   

7. Upon successful completion, a notification informs you that the on-demand backup is completed.

   

CLI

You can initiate an on-demand backup of a server via the az postgres flexible-server backup create command.

az postgres flexible-server backup create --resource-group <resource_group> --name <server> --backup-name <backup>

Note

Under any of the following circumstances, you receive an InternalServerError:

• If another on-demand backup with the same name already exists in that server.
• If another on-demand backup is being taken, and isn't completed yet.

List on-demand backups

Portal

Using the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server.

2. In the resource menu, under the Settings section, select Backup and restore.

   

3. In Backup types, select On-Demand backup if you want to only see the on-demand backups which are still available to be restored.

   

CLI

You can list currently available on-demand backups of a server via the az postgres flexible-server backup list command.

az postgres flexible-server backup list --resource-group <resource_group> --name <server> --query "[?backupType=='Customer On-Demand']" --output table

Delete on-demand backups

Portal

Using the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server.

2. In the resource menu, under the Settings section, select Backup and restore.

   

3. In Backup types, select On-Demand backup if you want to only see the on-demand backups which are still available to be restored.

   

4. Identify the on-demand backup that you want to delete. Then, under the Actions column, select Delete to initiate the deletion of that particular on-demand backup.

   

5. A notification informs you that the on-demand backup is being deleted.

   

6. Upon successful completion, a notification informs you that the on-demand backup is deleted.

   

CLI

You can delete any of the currently available on-demand backups of a server via the az postgres flexible-server backup delete command.

az postgres flexible-server backup delete --resource-group <resource_group> --name <server> --backup-name <backup>

If you run the previous command, it requires you to explicitly confirm, responding with a y (yes):

Are you sure you want to delete the backup '<backup>' in server '<server>'

If you want to run the command without needing the user interaction, you can add the --yes parameter like this:

az postgres flexible-server backup delete --resource-group <resource_group> --name <server> --backup-name <backup> --yes

Note

If you provide the name that doesn't match any of the available on-demand backups, the command doesn't report any error.

Related content

• Overview of business continuity with Azure Database for PostgreSQL - Flexible Server.
• Backup and restore in Azure Database for PostgreSQL - Flexible Server.