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.

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

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

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