Edit

Manage Azure Database for PostgreSQL server

  • Article

This article describes how to manage Azure Database for PostgreSQL servers that are backed up with the Azure Backup service.

Change policy

You can change the associated policy with a backup instance.

  1. Select the Backup Instance -> Change Policy.

    Screenshot showing the option to change policy.

  2. Select the new policy that you wish to apply to the database.

    Screenshot showing the option to reassign policy.

Stop protection

There are three ways to stop protecting an Azure Database for PostgreSQL server.

  • Stop Protection and Retain Data (Retain forever): This option helps you stop all future backup jobs from protecting your Azure Database for PostgreSQL server. However, Azure Backup service will retain the recovery points that are backed up forever. You'll need to pay to keep the recovery points in the vault (see Azure Backup pricing for details). You'll be able to restore from these recovery points, if needed. To resume protection, use the Resume backup option.

  • Stop Protection and Retain Data (Retain as per Policy): This option helps you stop all future backup jobs from protecting your Azure Database for PostgreSQL server. The recovery points will be retained as per policy and will be chargeable according to Azure Backup pricing. However, the latest recovery point will be retained forever.

  • Stop Protection and Delete Data: This option helps you stop all future backup jobs from protecting your Azure Database for PostgreSQL server and delete all the recovery points. You won't be able to restore the database or use the Resume backup option.

Stop protection and retain data

  1. Go to Backup center and select Azure Database for PostgreSQL server.

  2. From the list of server backup instances, select the instance that you want to retain.

  3. Select Stop Backup.

    Screenshot showing the selection of the Azure Database for PostgreSQL server backup instance to be stopped.

  4. Select one of the following data retention options:

    1. Retain forever
    2. Retain as per policy

    Screenshot showing the options for data retention to be selected.

    You can also select the reason for stopping backups from the drop-down list.

  5. Click Stop Backup.

  6. Select Confirm to stop backup.

    Screenshot for the confirmation for stopping backup.

Stop protection and delete data

  1. Go to Backup center and select Azure Database for PostgreSQL server.

  2. From the list of server backup instances, select the instance that you want to delete.

  3. Click Stop Backup.

  4. Select Delete Backup Data.

    Provide the name of the backup instance, reason for deletion, and any other comments.

    Screenshot showing the option to delete backup data and the detail required to be added.

  5. Select Stop Backup.

  6. Select Confirm to stop backup.

    Screenshot for the confirmation for stopping backup.

Resume protection

If you have selected the Stop Protection and Retain data option while stopping the data backup, you can resume protection for your Azure Database for PostgreSQL server.

Note

When you start protecting a database, the backup policy is applied to the retained data as well. The recovery points that have expired as per the policy will be cleaned up.

Follow these steps:

  1. Go to Backup center and select Azure Database for PostgreSQL server.

  2. From the list of server backup instances, select the instance that you want resume.

  3. Select Resume Backup.

    Screenshot showing the option to resume data protection.

  4. Select Resume backup.

    Screenshot showing the option to resume data backup.

Next steps

Backup vaults overview