Restoring a Database Group for Microsoft Azure Database for PostgreSQL

You can browse and restore one or more databases.

Before You Begin


  1. From the navigation pane, go to Protect > Databases.

    The database overview page appears.

  2. Click the Instances tab.

    The Instances page appears which displays the list of instances.

  3. Click an instance.

    The instance detail page appears.

  4. Click Database group tab.

    The Database groups page appears.

  5. From Actions column, click the ellipsis icon associated with a database group, and select Restore.

    The Backup content page appears.

  6. Select the databases that you want to restore, and then click Restore.

    The Restore options dialog box appears.

  7. To run an in-place restore operation, on the In place tab, verify that the destination client and the destination instance are the same as the source client and the source instance.

  8. To run an out-of-place restore operation, on the Out of place tab, select the destination client and the destination instance.

  9. From the Restore Type list, select a restore type.

  10. From the Destination Server list, select a destination.

  11. From the Destination Instance list, select a destination instance.

  12. In the Number of streams box, enter the number of data streams that you want to use for restore.

  13. To restore a Dumpbased backupset using parallel jobs, do the following:

    1. For restores for a Dumpbasedbackupset on Linux and Windows servers, in the Number of parallel jobs box, enter the number of parallel jobs to restore the database.

    2. In the Staging path box, enter the location to set the staging path to a local directory.

  14. To stage the global objects file after the restore is complete for a Dumpbased backupset, do the following:

    1. Select the Stage global objects file check box.

    2. To set the staging path for global objects file, in the Staging path box, enter the location in the destination access node.

  15. Click Submit.