Restoring a PostgreSQL Instance to a Different Host (Cross-Machine Restore)

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

  1. From the CommCell Browser, go to Client Computers > Client > PostgreSQL > Instance.

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

  3. On the Browse and Restore Options dialog box, click View Content.

  4. From the Browse window, select FSBasedBackupSet, and then click Recover All Selected.

    The PostgreSQL Database Restore Options dialog box appears.

  5. Select Restore out of place, and then click Next.

  6. From the Destination list, select the name of the destination client where you want to restore the PostgreSQL instance.

  7. 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.

  8. 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.

Loading...