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.