Schedule - PGConf.DE 2025
pgBackRest Advanced Archiving and Recovery Magic You’ll Wish You Knew Sooner
Date: 2025-05-08
Time: 11:20–12:05
Room: Madrid
Level: Intermediate
pgBackRest is a reliable and flexible backup solution for PostgreSQL, scaling effortlessly to handle even the largest databases and workloads. But like any tool, its true strength lies in knowing how to use it right. In this talk, we'll take a closer look at pgBackRest's archiving system, a key component of Point-in-Time Recovery (PITR). We'll explore its capabilities and limitations, and see how it can significantly boost PostgreSQL WAL archiving performance. While taking a backup might sound easy, restoring it to a specific point in time is another story. This session will also cover some advanced recovery techniques, including partial data restoration, and highlight the level of granularity pgBackRest offers to meet precise recovery targets. Already using pgBackRest or just considering it? This talk will show you how to unlock its full potential and take your PostgreSQL backup strategy to the next level.