Cross subscription and cross resource group restore in Azure Database for PostgreSQL - Flexible Server

  • Article

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

This article provides a step-by-step procedure for using the Azure portal to perform a restore to a different subscription or resource group in Azure Database for PostgreSQL flexible server through automated backups. You can perform this procedure to the latest restore point or to a custom restore point within your retention period.

Prerequisites

To complete this how-to guide, you need an Azure Database for PostgreSQL flexible server instance. The procedure is also applicable for an Azure Database for PostgreSQL flexible server instance that's configured with zone redundancy.

Restore to a different Subscription or Resource group

  1. In the Azure portal, choose the Azure Database for PostgreSQL flexible server instance that you want to restore.

  2. Select Overview from the left pane, and then select Restore.

    Screenshot that shows a server overview and the Restore button.

  3. Under Subscription drop down, select different subscription. If you want to change the Resource group go to next step else you can go to Step 5.

  4. Select Resource Group drop down, choose different Resource group

  5. Under Server details, for Name, provide a server name. For Availability zone, you can optionally choose an availability zone to restore to.

    Screenshot that shows selections for restoring to different subscription or resource group.

  6. Select Review + create and click create, a notification shows that the restore operation has started.

Geo Restore to a different Subscription or Resource group

If your source server is configured with geo-redundant backup, you can restore the servers in a paired region to a different resource group or subscription using below steps

Note

For the first time that you perform a geo-restore, wait at least one hour after you create the source server

  1. In the Azure portal, choose the Azure Database for PostgreSQL flexible server instance that you want to restore the backup from.

  2. Select Overview from the left pane, and then select Restore.

    Screenshot that shows a server overview.

  3. Under Subscription drop down, select different subscription. If you want to change the Resource group go to next step else you can go to Step 5.

  4. Select Resource Group drop down, choose different Resource group

  5. Check the Restore to paired region option

  6. Under Server details, for Name, provide a server name. For Availability zone, you can optionally choose an availability zone to restore to.

    Screenshot that shows selections for restoring to the latest point.

  7. Select Review + create and click create, a notification shows that the restore operation has started.

Related content