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

  1. Perform a backup.

  2. Verify that the PostgreSQL software version on the destination is the same version or higher than the software version.

  3. For FSBased backupset, 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.

  4. For DumpBased backupset, complete the following steps:

    • Select all the dependent objects before initiating a restore operation.

    • Roles and tablespaces to which the database or table belongs should preexist.

    • We connect to maintenance database to perform the restore operation. Hence, restore of maintenance database requires modifying the maintenance database in the instance details page to another database that will not be a part of the restore job.


  1. From the navigation pane, go to Solutions > Databases > DB Instances.

    The Instances page appears.

  2. Select the row of the instance that you want to restore, and click Restore.

    The Backup Content page appears.

  3. Restore all the databases or individual databases:

    • To restore all the databases, select the Database name check box, and then click Restore.

    • To restore individual databases, select the check boxes for the databases that you want to restore, and then click Restore.

    The Restore options dialog box appears.

  4. 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 Client list, select the destination host 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.

  5. Click Submit.

What to Do Next

You can control or view the job. For more information, see Jobs.