Restore PostgreSQL Database Tables and Instances from a Block-Level Backup
You can perform a table restore and a full instance restore to the same host or a different host from PostgreSQL block-level backups.
When you restore a table to a specific failure point, you must restore tables to a user-defined auxiliary instance. To restore individual database tables, select the tables from the list of database tables in a tree view and restore them to a destination location.
Best Practice: Include the parent tables with all dependent tables so that the reference constraints remain intact.
You can use one of the following methods to restore the PostgreSQL tables and instances:
Restoring PostgreSQL Tables
Restoring PostgreSQL Instances
- Restoring a PostgreSQL Instance to the Same Host
- Restoring a PostgreSQL Instance to a Different Host
Restoring Block-Level Volume Backups
Important: At the time of restore operation, the log files are downloaded to the staging directory. Ensure that the staging directory has sufficient space to hold the log files. The size of the staging directory depends on the total application size of the relevant log backups that you run in a cycle. For example, if there are five transaction log backups in a backup cycle, you can add up the application size of all the five log backups to decide on the size of the staging directory that you need.
Last modified: 11/23/2018 5:24:32 AM