Restores for Microsoft Azure Database for PostgreSQL

You can browse and restore backed up data of the following:

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.
Before initiating the out-of-place restores, create the destination instance and start the destination server.
Use additional setting bRestoreRolesFromGlobalFile to override the restore setting and create roles as specified in the global objects dump file.
You must only create roles that do not exist.

From the Command Center navigation pane, go to Protect > Databases.

The database Overview page appears.
Go to the Instances tab.
In the row for the instance, click the action button , and then click Restore.

Alternatively, click the instance you want to restore, and then in the Recovery points, click Restore.

The Backup content page appears.

Note

Ensure that you have performed a successful backup on the selected date.
From the Database view list, you can select the following two views:
- Database view
- Table view
Note

From the View selections tab, you can view your restore selections.
Click Restore.

The Restore options dialog box appears.
You can perform the following two types of restores:
- Perform In-place restore or Out-of-place restore of PostgreSQL Database.
- Perform In-place restore or Out-of-place restore of PostgreSQL tables.
Click Submit.