Efficiently backing up terabytes of data with pgBackRest
pgBackRest aims to be a simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads. It supports per file checksums, page checksums, compression, parallel backup/restore, delta restore, parallel asynchronous archiving, partial/failed backup resume, backup from standby, tablespaces and links, expiration, full/differential/incremental, local/remote operation via SSH, and more. This talk will introduce the features, give sample configurations, and talk about design philosophy.
pgBackRest aims to be a simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads. It supports per file checksums, page checksums, compression, parallel backup/restore, delta restore, parallel asynchronous archiving, partial/failed backup resume, backup from standby, tablespaces and links, expiration, full/differential/incremental, local/remote operation via SSH, and more. This talk will introduce the features, give sample configurations, and talk about design philosophy.
Instead of relying on traditional backup tools like tar and rsync, pgBackRest implements all backup features internally and uses a custom protocol for communicating with remote systems. Removing reliance on tar and rsync allows for better solutions to database-specific backup challenges. The custom remote protocol allows for more flexibility and limits the types of connections that are required to perform a backup which increases security.
Primary PgBackRest Features:
Parallel Backup/Restore with Compression
Per File Checksums for Backup Integrity
Page Checksums (when enabled) Verified During Backup
Full, Differential, and Incremental Backups
Backup from Standby
Delta Restore for Fast Recovery
Restore Single Database from a Cluster
Backup and Archive Expiration
Parallel Archive Command with Compression
Full Support for Tablespaces and Links with Remapping
