You can restore the database instance and tables.
You can perform the restore from the following two backup sets:
-
- Use FSBased backupset to perform the full database restore.
-
- 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.
-
Roles are restored by default if global objects are backed up. Starting from version 11.42.23, global objects are restored by default. If role creation on the destination is not desired, set the additional setting bRestoreRolesFromGlobalFile to False.
-
You must only create roles that do not exist.