Loading...

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

  1. Perform a backup.
  2. Verify that the PostgreSQL software version on the destination is the same version or higher than the software version.
  3. 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.

Procedure

  1. 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.

  2. Select the databases that you want to restore, and click Restore.

    The Restore Options dialog box appears.

  3. From the Destination Client list, select the destination host for the restore.
  4. From the Destination instance list, select the destination instance for the restore.
  5. 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