Restoring a Database Group for Microsoft Azure Database for PostgreSQL

You can browse and restore one or more databases.

Before You Begin

• To restore from a parallel DumpBased backup,do the following:

  • Use parallel jobs to dump the PostgreSQL database

  • Enter an optimal value for the number of parallel jobs based on the hardware setup of the server, client, and network. For more information, go to the -j command line argument in the PostgreSQL documentation website.

• To back up roles in the database, enable backups for global objects in the PostgreSQL database. The pg_dump utility that is used to perform DumpBased backup operation does not back up roles by default. If you did not have the global objects backed up already, to restore the data with the database user defined in the destination instance properties as the owner, create the additional settings bPGRestoreNoACL and bPGRestoreNoOwner before initiating the restore job.

Procedure

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.