You can restore PostgreSQL databases in the Amazon RDS cloud to the same instance as the backup or to a different instance. You can perform the restore operation from the Amazon RDS virtualization client computer.
Before You Begin
-
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 and tablespaces by default. To back up this information using the pg_dumpall utility, keep this option enabled during backup - enable backups for global objects in the PostgreSQL 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.
-
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, select the Stage global objects file check box.
-
Click OK.