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

You can restore objects to a different database on the destination client (cross-machine). 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 version of PostgreSQL.

  • The destination client meets the PostgreSQL system requirements for block-level backup.

  • PostgreSQL Agent and MediaAgent are installed on the destination client.

Procedure

  1. From the CommCell Browser, expand 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, identify the data that you want to restore.

  4. Select Table View and click View Content.

  5. From the Browse window, select tables to restore.

    Restriction: Do not select the maintenance database.

  6. Click Recover All Selected.

  7. Verify that the tables you selected for restore appear in the User Select Objects For Restore list.

  8. From the Destination list, select the name of the destination client where you want to restore the tables.

  9. Under Table Import Options, select the following options to further configure your restore operation:

    • To delete existing tables from the destination database before the database tables are restored and imported, select Drop Table for Import.

    • To restore tables without importing, select Skip Import. In the Staging Path for Logs and Dump Files box, type the path or click Browse to select the path where you want to export the tables.

  10. On the Table Restore Options tab, select Point-in-time, and then set the restore date, time, and time zone to appropriate values.

    Note: The latest backup cycle is selected by default. To perform a point-in-time restore from an earlier cycle, browse from the respective cycle.

  11. Optional: Select Specify Destination Database for Table Import.

  12. Next to the source database for which you want to specify a target database name, click the Target Database column and enter the target database name.

    Note: This option is unavailable if you select the Skip Import check box.

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