pgBackRest: Elevating PostgreSQL Backup Game
summary
pgBackRest installs from packages, uses a repo at data/data/backups, and configures a stanza holding metadata; demo shows enabling archive_command enabled (archive_mode on) and passwordless SSH, then a fast full followed by incremental and differential backups (full/incremental/differential). Differential cuts restore time by skipping prior incrementals at the cost of space. Restoration requires PostgreSQL stopped and an empty data directory; single-database restores succeed but other databases remain inaccessible. Compared to Barman, Barman adds parallelism; pgBackRest offers differential backups.
AI-written summary · about
chapters (16)
- 0:00Introduction and speaker background
- 1:06What is pgBackRest
- 2:30Key features of pgBackRest
- 4:15Installation and setup
- 5:17Understanding stanza and configuration
- 6:22Backup types explained
- 10:18Demo environment setup
- 13:55Configuring pgBackRest
- 19:08Creating a stanza
- 21:38Checking configuration with check command
- 24:25Taking full backup
- 25:50Taking incremental backup
- 26:54Taking differential backup
- 28:40Restoring backups
- 34:02Restoring single database
- 38:41Resources and closing
related talks
51mHeavy Duty Backup w/PgBackRest
49mWhat can't pgBackRest do for you?
50mPostgreSQL Backup and Recovery Methods
49mTools for Creating PostgreSQL Backups
56mI Dropped My Database! Now What? - A Dive Into PostgreSQL Backup Using pgBackRest
56mPostgreSQL Backup Strategies
48mCTRL+Z for your Database : Mastering Backup and Recovery in PostgreSQL
02h 30mTutorial