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
-
From the CommCell Browser, navigate to client > PostgreSQL > source_instance.
-
Right-click FSBasedBackupset, and then click All Tasks > Browse and Restore.
-
Click View Content.
-
Select the data that you want to restore, and then click Recover All Selected.
The PostgreSQL Database Restore Options dialog box appears.
-
On the General tab, from the Destination Server list, select the destination instance.
-
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.
-
-
Click Advanced.
The Advanced Restore Options dialog box appears.
-
On the Redirect tab, select the Redirect check box to enable the redirect restore operation.
-
From the Source Path column, select a path that you are restoring data from.
-
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.
-
Click Apply to select the new destination path.
-
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.