> Essential > Databases > PostgreSQL

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 or cluster instance (If it is a cluster restore) on the destination client before initiating an out of place restore.

  • For FSBasedBackupSet, 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 FSBasedBackupSet, the source computer and destination computer should have the same operating system.

  • For a DumpBased backup set, do the following:

    • To back up roles and tablespaces in the database or table, enable backups for global objects in the database. The pg_dump utility that is used to perform DumpBased backup operation does not back up roles and tablespaces by default. If you did not have the global objects backed up already, to restore the data with the database user defined in the destination instance properties as the owner, create the additional settings bPGRestoreNoACL and bPGRestoreNoOwner before initiating the restore job.

    • To restore maintenance database, modify the maintenance database in the Instance details page to another database that will not be a part of the restore job.

    • The source computer and destination computer should have the same operating system.

    • Use parallel jobs to dump the PostgreSQL database.

    • Enter an optimal value for the number of parallel jobs based on the hardware setup of the server, client, and network. For more information, go to the -j command line argument in the PostgreSQL documentation website

Procedure

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

    The database Overview page appears.

  2. Go to the Instances tab.

  3. Click the instance that you want to restore.

    The instance Overview page appears.

  4. In the Recovery points calendar tile, select FSBasedBackupSet or DumpBasedBackupSet.

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

  6. Select the database(s) and click Restore.

    The Restore options dialog box appears.

  7. You can perform the following two types of restores:

Loading...