Learn how to efficiently back up terabytes of data using PgBackRest, an open-source software designed for PostgreSQL databases. This course covers features such as per file checksums, compression, partial/failed backup resume, high-performance parallel transfer, and more. The teaching method includes introducing features, providing sample configurations, and discussing design philosophy. This course is intended for individuals working with PostgreSQL databases, especially those dealing with large amounts of data.
Efficiently Backing Up Terabytes of Data with PgBackRest
Overview
Syllabus
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
Taught by
USENIX
