Efficiently Backing Up Terabytes of Data with PgBackRest

Explore efficient backup strategies for large-scale PostgreSQL databases in this 35-minute conference talk from LISA15. Learn about PgBackRest, an open-source software designed to handle backups for databases measuring tens of terabytes and beyond. Discover its key features, including per-file checksums, compression, partial/failed backup resume, high-performance parallel transfer, and asynchronous archiving. Gain insights into sample configurations, design philosophy, and practical applications from the software's author. Delve into topics such as full, differential, and incremental backups, local and remote operations via SSH, hard-linking, and restoration processes. Understand the importance of backups, explore the backup structure, and witness a live demonstration covering full backups, archive directories, and creative restore points. Acquire valuable knowledge on database recovery, cluster management, and accessing backup information through JSON output.

Introduction
Why Back Up
Practical Uses
Schroeders Backup
Postgres Backup
Design
Features
Backup Structure
Performance
Demo
Full Backup
Archive Directory
Differential
Release Backup
Creative Restore Point
Release
Recovery
Stop Database
Restart Cluster
Getting the Data
Getting Information
JSON Output