CTRL+Z for your Database : Mastering Backup and Recovery in PostgreSQL
October 21–24
What if you could hit CTRL+Z when your production database crashes, someone drops a critical table, or a cloud region outage takes your system offline? In this talk, we’ll explore how to build a disaster-resilient PostgreSQL system : one that not only backs up data efficiently but also recovers gracefully when the unexpected happens. From traditional SQL dumps to the new incremental backup feature introduced in PostgreSQL 17, we’ll cover practical strategies you can use in real-world environments. Key Takeaways : 1) Why backups matter and how to choose the right type for your use case 2) PostgreSQL backup options: logical vs physical, full vs incremental 3) Point-in-Time Recovery (PITR), WAL archiving, delayed replicas, and failover testing 4) What's new in PostgreSQL 17: pg_basebackup with incremental mode, pg_combinebackup, and --filter in pg_dump 5) How to design PostgreSQL systems for durability, high availability, and quick recovery Whether you're managing a single instance or a fleet of databases in production, this session will help you build a resilient PostgreSQL environment ready to handle real-world challenges with confidence and control.
