Proposed Pull Request Change

📄 Document Links

View on GitHub View on Microsoft Learn

--- title: Quickstart - Restore a PostgreSQL database across regions using Azure Backup description: Learn how to restore a PostgreSQL database across regions by using Azure Backup. ms.topic: quickstart ms.date: 01/27/2026 ms.service: azure-backup ms.author: v-mallicka # Customer intent: "As a database administrator, I want to enable Cross Region Restore for my PostgreSQL database, so that I can ensure data availability and perform restoration drills in case of regional failures or compliance audits." --- # Quickstart: Restore a PostgreSQL database across regions by using Azure Backup This quickstart describes how to enable Cross Region Restore on your Backup vault to restore the data to an alternate region when the primary region is down. With Cross Region Restore, you can restore data to a secondary [Azure paired region](/azure/reliability/cross-region-replication-azure) at any time. This feature allows you to perform drills for audits or compliance, even if the primary region is working normally. > [!NOTE] >- Currently, Geo-redundant Storage (GRS) vaults with Cross Region Restore enabled can't be changed to Zone-redundant Storage (ZRS) or Locally redundant Storage (LRS) after the protection starts for the first time. >- Cross Regional Restore (CRR) with Cross Subscription Restore (CSR) is currently not supported. ## Prerequisites To begin with the Cross Region Restore, ensure that: - A Backup vault with Cross Region Restore configured. [Create one](./create-manage-backup-vault.md#create-a-backup-vault) in case you don’t a Backup vault. - PostgreSQL database is protected by using Azure Backup, and one full backup is run. To protect and back up a database, see [Back up Azure Database for PostgreSQL server](backup-azure-database-postgresql.md). ## Restore the PostgreSQL database using Azure portal To restore the database to the secondary region using the Azure portal, follow these steps: 1. Sign in to [Azure portal](https://portal.azure.com/). 1. To check the available recovery point in the secondary region, go to the **Backup vault** > **Backup Instances**. 1. Filter to **Azure Database for PostgreSQL servers**, then filter **Instance Region** as *Secondary Region*. 1. Select the required Backup instance. The recovery points available in the secondary region are now listed. 1. Select **Restore to secondary region** to review the target region selected, and then select the appropriate recovery point and restore parameters. You can also trigger restores from the respective backup instance. :::image type="content" source="./media/create-manage-backup-vault/restore-to-secondary-region.png" alt-text="Screenshot showing how to restore to secondary region." lightbox="./media/create-manage-backup-vault/restore-to-secondary-region.png"::: 1. Once the restore starts, you can monitor the completion of the restore operation under **Backup Jobs** of the Backup vault by filtering **Datasource type** to *Azure Database for PostgreSQL servers*  and **Instance Region** to *Secondary Region*. ## Next steps - [Learn about the Cross Region Restore](./tutorial-cross-region-restore.md) feature.