CTRL+Z for your Database : Mastering Backup and Recovery in PostgreSQL

on YouTube ↗48m

" summary

Covers building disaster-resilient PostgreSQL systems by comparing backup types (logical vs physical, full vs incremental) and explaining recovery tools and practices such as PITR, WAL archiving, delayed replicas, and failover testing. Describes PostgreSQL 17 features including pg_basebackup incremental mode, pg_combinebackup, and --filter in pg_dump, and gives guidance on designing for durability, high availability, and fast recovery.

AI-written summary · about

" related talks

• 50mPostgreSQL Backup and Recovery MethodsKevin Kempter · PostgresOpen 2013
• 49mTools for Creating PostgreSQL BackupsAndrey Salnikov · HighLoad++ Moscow 2018
• 22mPostgreSQL Disaster Recovery FundamentalsRilwan Musa · Postgres Conference Orlando 2025
• 56mI Dropped My Database! Now What? - A Dive Into PostgreSQL Backup Using pgBackRestCharly Batista · Percona Community Live 2022
• 56mPostgreSQL Backup StrategiesMagnus Hagander · Postgres Open 2012
• 50mAn ultimate guide to upgrading your PostgreSQL installationIlya Kosmodemiansky · PostgreSQL Conference Europe 2024
• 31mImplementing Disaster RecoverySergey Burladyan · HighLoad++ 2015
• 59mPostgreSQL Don'ts and DosMagnus Hagander · foss-north 2026