Schedule - FOSDEM PGDay 2026

pgBackRest magic you'll wish you knew sooner

Date: 2026-01-30
Time: 10:50–11:40
Room: Ballroom B
Level: Intermediate

pgBackRest is a reliable and flexible backup solution for PostgreSQL, built to scale effortlessly for even the largest databases and most demanding workloads. But like any tool, its true power comes from knowing how to use it right.

In this talk, we'll take a closer look at pgBackRest's archiving system, a core component of Point-in-Time Recovery (PITR). You'll learn its capabilities and limitations, and see how asynchronous operations can significantly boost PostgreSQL WAL archiving performance.

We'll also explore advanced recovery techniques, including partial data restoration, to show how pgBackRest unlocks recovery scenarios that PostgreSQL itself does not normally support.

Already using pgBackRest or just considering it? This talk will help you reach its full potential and bring your PostgreSQL backup and recovery strategy to the next level.

Speaker

Stefan Fercot