Performing a Redirect Restore Operation

You can perform a redirect restore operation to redirect all tablespaces and databases to a different path in the destination client. You can run a redirect restore operation when the current path has run out of space and you want to redirect the data directory to a different location, or for troubleshooting. You can redirect an entire database (all tablespaces) to a new client.

Limitations

  • You can perform redirect restore operations only on FSBased backup set.

  • You can perform redirect restore operations only on regular backups and IntelliSnap backups.

Before You Begin

  • Verify that you have a PostgreSQL instance on the CommCell Console both at the source server and the destination server.

  • The versions of PostgreSQL on both the source server and the destination server must be the same.

  • Create a PostgreSQL instance on the destination client.

    For steps to create a PostgreSQL instance, see Creating an Instance.

  • If you are performing a redirect restore on the same server, but a different location, verify that you have enough space in the new location. The PostgreSQL user should also have full access to the new location.

  • Before you perform a redirect restore operation, you must delete or rename the data directory, user tablespace directory, archive log directory and transaction log directory that is outside the data directory.

  • Stop the destination server.

  • Run a backup operation from the default subclient of an FSBased backup set.

Procedure

  1. From the CommCell Browser, navigate to client > PostgreSQL > source_instance.

  2. Right-click FSBasedBackupset, and then click All Tasks > Browse and Restore.

  3. Click View Content.

  4. Select the data that you want to restore, and then click Recover All Selected.

    The PostgreSQL Database Restore Options dialog box appears.

  5. On the General tab, from the Destination Server list, select the destination instance.

  6. If one or both of the following are true, then clear the Recover Database Server check box.

    • You do not want the PostgreSQL Server to start automatically after the restore operation is complete.

    • You are restoring an instance that has a UNC path as its Archive Log Directory. After the restore operation is complete, you can start the PostgreSQL Server manually.

  7. Click Advanced.

    The Advanced Restore Options dialog box appears.

  8. On the Redirect tab, select the Redirect check box to enable the redirect restore operation.

  9. From the Source Path column, select a path that you are restoring data from.

  10. In the New Path box, you can type or browse to the new destination path where you want to restore the data.

    Note

    If you are redirecting to a different path on the same server, the source and the destination instances would be the same. Provide a different location on the same server to redirect the restore.

  11. Click Apply to select the new destination path.

  12. Click OK to run the redirect restore operation.

Results

  • The Data directory is restored to the new destination path that you specified.

  • Log files are restored to the log file directory that is specified on the destination instance.

Loading...