Performing Individual Database Restore
You can restore individual databases by using the data backups that you previously performed on the subclients of the DumpBasedBackupSet.
Before You Begin
- Perform a backup.
- Verify that the PostgreSQL software version on the destination is the same version or higher than the software version.
- You cannot select maintenance database for a database level restore operation. You can only perform a table level restore operation. Before initiating a restore operation, drop all the objects in the database. Select all the dependent objects before initiating a restore operation. Roles and tablespaces to which the database or table belongs should preexist.
- You can perform a restore on the instances page, instance details page, or job details page.
- Instances: From the navigation pane, click Solutions > DB Instances, in the Restore column, click Restore.
- Instance details: From the navigation pane, click Servers > server > PostgreSQL > instance > DumpBasedBackupSet > subclient, in the Restore column, click Restore.
- Job details: From the navigation pane, click Jobs > job ID, in the Job summary area, click Restore.
The Backup Content page appears.
- Select the databases that you want to restore, and click Restore.
The Restore Options dialog box appears.
- From the Destination Client list, select the destination host for the restore.
- From the Destination instance list, select the destination instance for the restore.
- Click Submit.
What to Do Next
You can control or view the job. For more information, see Jobs.
Last modified: 10/3/2018 10:21:53 AM