Restoring One or More PostgreSQL Databases

You can browse and restore backed up data for an entire database or for individual databases.

Use FSBased backupset, to restore the entire database.

Use DumpBased backupset, to restore the individual databases.

Before You Begin

  • Perform a backup.

  • Verify that the PostgreSQL software version on the destination is the same version or higher than the version of source.

  • You must create an instance on the destination client before initiating out of place restore.

  • For FSBased backup set, 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.

    Note

    For FSBased backup set, it is assumed that the 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.

  • For a DumpBased backup set, do the following:

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. Click the instance that you want to restore.

    The instance page appears.

  3. In the Recovery points calendar, select FSBasedBackupSet or DumpBasedBackupSet.

  4. Select a date from the calendar, and then click Restore.

    The Backup content page appears.

    Note

    Ensure that you have performed a successful backup on the selected date.

  5. To select the content to restore, from the Restore from default copy box, select a copy to perform the restore operation.

  6. Click Restore.

    The Restore options dialog box appears.

  7. Follow the steps for the type of restore operation you want to run:

    • To run an out-of-place restore operation, complete the following steps:

      1. From the Destination Server list, select the destination server for the restore.

      2. From the Destination instance list, select the destination instance for the restore.

    • For an in-place restore operation, the destination client and the destination instance remain the same as the source client and the source instance.

  8. In the Number of streams box, enter the number of data streams to use in the restore operation.

  9. For DumpBasedBackupSet, to restore database using parallel jobs, in the Number of parallel jobs box, enter the number of parallel jobs to restore the database.

  10. In the Staging Path box, enter the path to stage the database dump. The staging location must have sufficient space based on the selection of databases for restore. Maximum of four databases can be staged at a time.

  11. Select the Stage global objects file check box to stage the global objects information.

  12. Click Submit.

Loading...