During the browse and restore operation, you can select multiple PostgreSQL database tables to restore them to an existing Azure database instance, a new Azure database instance, or a local client.
Before You Begin
-
Perform a backup operation. For more information, see Performing a PostgreSQL Database Backup Operation for an Azure Database.
-
To restore from a parallel DumpBased backup, do the following:
-
If you want to perform stage free restores for Linux clients, verify that the nfs-utils package is installed on the client and configure the 3DFS cache path on theMediaAgent that hosts the 3DFS server.
-
For stage free restores, verify that the following ports are open:
-
For the MediaAgent on a Windows computer, open 111, 445, 2049, and 2050.
-
For the MediaAgent on a Linux computer, open 111 and 2049.
-
-
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.
-
Create the required roles and tablespaces in the destination. The pg_dump utility that is used to perform DumpBased backup operation does not back up roles by default. To back up this information using the pg_dumpall utility, Enable backups for global objects in the PostgreSQL database during backup.
-
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.
-
In the source if the object selected to restore depends on an extension, ensure that the extension exists in the destination database.
Procedure
-
From the CommCell Browser, navigate to Client > PostgreSQL > Instance > DumpBasedBackupSet.
-
Right-click the subclient, and then click Browse and Restore.
The Browse and Restore Options dialog box appears.
-
To restore tables, select the Table Level Browse check box.
-
Identify the data that you want to restore, and then click View Content.
-
From the Browse window, select databases to restore, and then click Recover All Selected.
The PostgreSQL Database Restore Options dialog box appears.
-
Depending on the type of restore you want to run, select one of the following options:
-
To run an in-place restore, select Restore in place, and then click Next.
-
To run an out-of-place restore, select Restore out of place, and then click Next. Select a name of the destination client and a destination instance.
-
-
In the Number of streams box, enter the number of data streams to use in the restore operation.
-
In the Number of parallel jobs box, enter the number of parallel jobs to restore the database.
-
To perform staged restore of database, do the following:
-
Select Staged restore.
-
In the Staging path box, enter the location to set the staging path to a local directory.
-
-
To perform stage-free restore of database, do the following, select Stage-free restore.
Note
To add user name and password, you need to enable the following additional settings:
-
To stage the global objects file after the backup is complete for a Dumpbasedbackupset, do the following:
-
Select the Stage global objects file check box.
-
To set the staging path for global objects file, in the Staging Path box, enter the location.
If the staging location is not set, by default, the job results directory is used.
-
-
To restore tables to a staging location without importing to the server, select the Skip Import check box. In the Staging Path for Logs and Dump files box, type the path where you want to export the tables.
-
Click OK.