Securing Postgres with streaming replication | POSETTE: An Event for Postgres 2025

Video of a conference talk about how to secure your database in Postgres using streaming replication, from the very BASIC to the very ADVANCED. After all, even if your database is small, your data might still be precious. And as your project grows and gets bigger, your Postgres environment will need to be adapted to scale with it. This talk will give you a beginner’s guide to streaming replication in Postgres and more specifically you will learn about WAL (write-ahead logging), how to prepare for DR, and how to prepare for a large setup with cascading replicas, continuous backup, etc. You’ll also learn about the concepts of RTO and RPO and how to scale your data protection architecture as your application grows. Why attend this talk? Because the amazing power of streaming replication in PostgreSQL is too under-appreciated. Based on over two decades of practical experience, you will be guided through some of the pitfalls and get introduced to the full range of Postgres Disaster Resilience techniques. Jan Karremans leads the sales organization at CYBERTEC boasting over 30 years of experience in the database market. As an Oracle ACE alumni as well as a certified PostgreSQL professional, Jan is a well-respected expert in relational database technologies. Combining technology, business, and commercial aspects enables a unique understanding of customer cases and guiding customers and partners to success with Postgres. ► Video bookmarks: ⏩ 00:00 Introduction and agenda ⏩ 02:08 What is streaming replication? ⏩ 04:53 Transaction log ⏩ 05:59 Characteristics ⏩ 07:22 Scaling PostgreSQL safely (nearly) to infinity ⏩ 09:47 Primary and replica ⏩ 10:27 Async and sync ⏩ 16:01 Primary and Cascading replicas ⏩ 17:55 Solid foundation ⏩ 18:55 Corollaries ⏩ 21:05 Conclusion Resources: https://www.oapg-edu.org 📕 Everything you need to know about POSETTE: An Event for Postgres 2025 can be found at: https://posetteconf.com ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist 📌 Let’s connect:   LinkedIn - https://www.linkedin.com/company/posetteconf/ X – @PosetteConf, https://twitter.com/PosetteConf Mastodon – @posetteconf, https://mastodon.social/@posetteconf Bluesky – @posetteconf.com, https://bsky.app/profile/posetteconf.com _________________________________ #PosetteConf #PostgreSQL #replication