Stefan Fercot


Stefan brings to Data Egret close to 15 years of expertise in the database space, boasting extensive experience in client support, maintenance, and architectural consulting. His impact on Postgres development is significant, notably as one of the contributors to pgBackRest, a reliable backup and restore solution for PostgreSQL. Stefan is a familiar face at Postgres community events, including FOSDEM, pgDay France, and PGconf.EU, where he draws inspiration for his upcoming development projects. Based in Belgium, Stefan not only excels in the database world but also finds joy in the art of cooking and in badminton.

Talk Description: Mastering PostgreSQL Recovery: Beyond Backup Basics

While PostgreSQL's Continuous Archiving and Point-in-Time Recovery mechanisms are extensively covered in the documentation, navigating the intricacies of successful recovery remains a challenging aspect for beginners. Creating a consistent backup is now easily achievable with the plethora of available tools, but the journey from backup to recovery demands a deeper understanding of the process.

This talk aims to demystify the complexities of PostgreSQL recovery, guiding participants through a comprehensive exploration of Point-in-Time Recovery and the critical role of Write-Ahead Logging (WAL) archives. Starting with a succinct overview, we will delve into the nuanced steps required to effectively restore a backup while shedding light on the multitude of settings influencing PostgreSQL recovery.

Drawing from practical scenarios and diverse recovery targets, attendees will gain valuable insights into mastering the recovery process. By the end of the session, participants will have a solid understanding of the intricacies involved, empowering them to confidently navigate PostgreSQL recovery challenges and optimize their database management strategies.