> Expert > Backup and Restore Agents > Databases > PostgreSQL > PostgreSQL Block-Level Backup > Restore PostgreSQL Database Tables and Instances from a Block-Level Backup

Restoring PostgreSQL Tables to the Same Host

By default, the software restores a database table to the same location from where it was backed up. You can also restore database tables to a different PostgreSQL instance.

You can perform a point-in-time restore, which is useful when you must recover the changes made to a database object up to a given point in time. You can select and restore the database object to a state that it had previous to that point.

Note

Do not use this method to restore a PostgreSQL Server. For instructions to perform a full instance restore, see Restoring a PostgreSQL Instance to the Same Host.

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 Level Browse, and then click View Content.

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

    Restriction: Do not select the maintenance database.

  6. Click Recover All Selected.

    The PostgreSQL Database Restore Options dialog box appears.

  7. Select Restore in place, and then click Next.

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

  9. Optional: To restore the selected tables to a different instance on the same client, from the Destination Server list, select the name of the destination instance.

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

    • To delete existing tables from the destination database before the 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.

  11. Optional: 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.

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

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

  14. Click OK.

Loading...