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.
If you're a DBA, you know how nerve-wracking it can be to perform a major PostgreSQL version upgrade without throwing your users or their applications into chaos. In this session, I'll share how we reliably manage to minimize downtime for our customers by using a combination of PostgreSQL streaming replication, PgBouncer, and pgBackRest.
We'll start by discussing why these upgrades are so important and explore some of the common strategies people use to tackle them. From there, I'll walk you through the process we use regularly, showing how our setup with PgBouncer and pgBackRest works and why it makes such a big difference.
You'll leave this session with practical tips and a clearer understanding of how to tweak your PostgreSQL setup to make upgrades less stressful, hopefully giving you the confidence to keep your clusters up to date more often!