Chapter 24. Backup and Restore

Table of Contents

24.1. Continuous Archiving and Point-in-Time Recovery (PITR)
24.1.1. Setting Up WAL Archiving
24.1.2. Timelines
24.1.3. Tips and Examples
24.1.4. Caveats
24.2. Backup and Recovery in Distributed System
24.2.1. Requirements for Backup and Restore with pg_probackup
24.2.2. pg_probackup Backup Process
24.2.3. Cluster Restore from a Backup with pg_probackup
24.2.4. Merging Backups with pg_probackup
24.2.5. Deleting Backups with pg_probackup

As with everything that contains valuable data, Postgres Pro Shardman databases should be backed up regularly. While the procedure is essentially simple, it is important to have a clear understanding of the underlying techniques and assumptions.