Restoring the Greenplum Database to a Different System

Use this procedure when you want to restore the databases to the Greenplum Database system host that is different from the backup and that has the same number of segments.

You can perform this procedure when a host has been damaged or destroyed.

The destination host must have a Greenplum version that is the same or higher than the source database.

Before You Begin

1. Perform a Greenplum backup.

2. Plan the configuration for the restore operations. After selecting the data that you want to restore, you will need to set the Advanced Restore Options for the restore operation.

   • General

   • Startup

   • Pre/Post

   • Copy Precedence

   • Data Path

   • Paths/Filters

   • Encryption

   • Map

Procedure

1. From the CommCell Browser, expand Client Computers > client > Greenplum > instance.

2. Right-click the subclient, point to All Tasks and then click Browse and Restore.

3. On the Browse and Restore dialog box, select Latest Backup and click View Content.

4. Optional: Use non-default Browse and Restore options. See Browse and Restore.

5. From the Browse window, select the database to restore in the right pane and click Recover All Selected.

   The Restore Options dialog box is displayed.

6. On the General tab, from the Destination Client list, select the new master host.

7. On the Job Initiation tab, specify whether to run the backup now or if it will be scheduled.

   Note

   If you selected Schedule, set up the schedule.

   For information on configuring a restore schedule, see Schedule Restores.

8. Click OK to close the Restore Options dialog box and start the restore.