A cross-machine restore is one in which the restore destination is a different client from the client where the backup was taken.
Before You Begin
Check whether you meet the following requirements:
-
The source and destination clients have the same major version of PostgreSQL Server.
-
Data directory path and tablespace location in the source and the destination clients are the same.
If they are different, then redirect the data directory to a different path by performing a redirect restore operation.
-
The destination client meets the PostgreSQL system requirements for block-level backup.
-
PostgreSQL Agent and MediaAgent are installed on the destination client.
-
Stop the PostgreSQL server, and delete or rename the data directory, user tablespace directory, archive log directory and transaction log directory that is outside the data directory.
Procedure
-
From the CommCell Browser, go to Client Computers > Client > PostgreSQL > Instance.
-
Right-click FSBasedBackupSet, point to All Tasks, and then click Browse and Restore.
-
On the Browse and Restore Options dialog box, click View Content.
-
From the Browse window, select FSBasedBackupSet, and then click Recover All Selected.
The PostgreSQL Database Restore Options dialog box appears.
-
Select Restore out of place, and then click Next.
-
From the Destination list, select the name of the destination client where you want to restore the PostgreSQL instance.
-
In the Number of Streams box, enter the number of streams to use in the restore operation.
By default, the number of streams is set to 2.
-
Click OK.
Note
During a cross machine restore, group ID and user ID at the source machine and the destination machine should be the same, else the restore operation will fail.