PostgreSQL Backup and Recovery Methods
summary
Covers concrete commands and tradeoffs: use pg_dump/pg_restore (plain, tar, custom), dump-only-schema or data, create list files to omit objects, and run pg_restore with -j parallel jobs to cut restores dramatically — the presenter cites restores dropping from 24 hours to 30 minutes. Shows cluster-wide pg_dumpall for globals, and full point-in-time recovery using base backups plus archived WAL files, archive_command examples, recovery.conf setup, and practical backup cadence recommendations.
AI-written summary · about
chapters (16)
- 0:00Start
- 8:30pg dump-Common Options (continued)
- 10:57pg dump-Examples
- 12:44pg dump Common Options (continued)
- 14:13pg dumpall - Common Options
- 16:11pg dumpal-Examples
- 21:13pg restore - Common Options
- 22:18pg restore Common Options continued
- 22:28pg restore-Common Options continued
- 26:00pg restore-Examples
- 27:45Create a list file from the pg_dump file
- 31:57PITR Overview
- 34:31PITR Setup
- 42:30PITR Example-create transactions
- 42:46PITR Example-create base backup
- 44:17PITR recovery.conf file (common options)
related talks
56mPostgreSQL Backup Strategies
48mCTRL+Z for your Database : Mastering Backup and Recovery in PostgreSQL
59mPostgreSQL Don'ts and Dos
49mTools for Creating PostgreSQL Backups
22mPostgreSQL Disaster Recovery Fundamentals
56mI Dropped My Database! Now What? - A Dive Into PostgreSQL Backup Using pgBackRest
50mAn ultimate guide to upgrading your PostgreSQL installation
02h 30mTutorial