A cross-machine restore is one in which the restore destination is a different client from the client where the backup was taken.
Important
Do not use this method if you have files or folders other than PostgreSQL data directory, tablespace directory and archive log directory in the same volume. In such a case, you can perform a table level browse operation and a database level restore operation excluding the maintenance and template database.
Before You Begin
Check whether you meet the following requirements:
-
The source and destination clients have the same version of PostgreSQL Server.
-
The source and the destination clients have the same port and the same archive directory location.
-
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, expand 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 is displayed.
-
From the Destination list, select the name of the destination client where you want to restore the PostgreSQL instance.
-
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.