PGCon2017 - 20180510

PGCon 2017
The PostgreSQL Conference

David Steele
Day Talks - Day 1 - 2017-05-25
Room DMS 1160
Start time 13:00
Duration 00:45
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