Choosing a Replication System for PostgreSQL

on YouTube ↗48m

" summary

Compares PostgreSQL replication systems and how to choose among them for different needs like high availability, backup, and scaling when data won’t fit on one machine. Discusses concrete replication technologies and approaches available for PostgreSQL (synchronous vs asynchronous replication, physical vs logical replication, and typical tools/configurations) and criteria for selecting the right solution for a project.

AI-written summary · about

" chapters (8)

1. 0:00Introduction
2. 3:01Replication tasks in PostgreSQL
3. 7:56Physical replication pros and cons
4. 16:46Trigger and logical replication
5. 22:28Cluster systems and sharding
6. 27:37Write balancing and multi-master
7. 33:41System selection recommendations
8. 35:32Q&A

" related talks

• 10mBackups Are Good, Replicas Are Better: Demystifying Replication on PostgreSQLDan FAUDEMER · DevFest Toulouse 2024
• 49mPostgreSQL Replication - The Most Exciting Technology on EarthEdward Snajder · Open Source Bridge 2013
• 52mNew Data Replication Technologies in PostgreSQLAleksandr Alekseev · HighLoad++ 2017
• 50mMoving from MSSQL to pgSQL – High Availability and Disaster RecoveryRick Lowe · Postgres Conference Orlando 2025
• 48mPostgreSQL Replication: 20 Pitfalls and SolutionsJulian Markwort · PostgreSQL Conference Europe 2023
• 51mPostgreSQL Replication Conflicts: Avoiding PitfallsHamid Quddus Akhtar · Percona Community Live 2022
• 53mThe journey towards active replication in PostgreSQLJonathan S. Katz, Amit Kapila · PGCon 2023
• 31mPast, Present, and Future: Logical Decoding and Replication in PostgreSQLHari P Kiran · POSETTE: An Event for Postgres 2026