You can restore the tables of a PostgreSQL database 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.
-
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 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.