pgBackRest aims to be a reliable, easy-to-use backup and restore solution that can seamlessly scale up to the largest databases and workloads by utilizing algorithms that are optimized for database-specific requirements.
pgBackRest is a way to get reliable scalable backup and restore of PostgreSQL databases. It has several features including:
- Parallel Backup & Restore using algorithms like lz4 and zstd.
- Local or Remote Operation using a custom protocol; can use TLS/SSH with minimal configuration
- Multiple Repositories allow, for example, a local repository with minimal retention for fast restores and a remote repository with a longer retention for redundancy
- Full, Incremental, & Differential Backups which are not susceptible to the time resolution issues of rsync
- Backup Rotation & Archive Expiration; the WAL archive can be maintained for all backups or strictly for the most recent backups
- Backup Integrity where checksums are calculated for every file in the backup and rechecked during a restore or verify
- Page Checksums can validate the checksums for every file that is copied during a backup
- Backup Resume from the point where it was stopped
- Streaming Compression & Checksums while files are being copied to the repository
- Delta Restore to speed processing enormously
- Parallel, Asynchronous WAL Push & Get
- Tablespace & Link Support are fully supported and on restore tablespaces can be remapped to any location
- S3, Azure, and GCS Compatible Object Store Support
- Encryption
- Compatibility with ten versions of PostgreSQL
