Restoring a PostgreSQL Database

You can restore the database instance and tables.

You can perform the restore from the following two backup sets:

• FSBasedBackupSet

  • Use FSBased backupset to perform the full database restore.

• DumpBasedBackupSet.

  • Use DumpBased backupset to restore the individual database instance.

  Note

  Restoring to an instance with an older PostgreSQL version is not supported. For more information, see PostgreSQL documentation for details.

• Use additional setting bRestoreRolesFromGlobalFile to override the restore setting and create roles as specified in the global objects dump file.

• You must only create roles that do not exist.