PGCon2017 - 20180510
PGCon 2017
The PostgreSQL Conference
| Speakers | |
|---|---|
|
David Steele |
| Schedule | |
|---|---|
| Day | Talks - Day 1 - 2017-05-25 |
| Room | DMS 1160 |
| Start time | 13:00 |
| Duration | 00:45 |
| Info | |
| ID | 1088 |
| Event type | Lecture |
| Track | DBA |
| Language used for presentation | English |
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.
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 Remappping