PostgreSQL Replication - The Most Exciting Technology on Earth

on YouTube ↗49m

" summary

Postgres offers many replication approaches and the decisive details are clear here not just the topic streaming replication in 9.1+ is showcased as the simplest and most reliable option a live demo uses pg_basebackup to spin up a standby in two commands and shows fast cascading to multiple subscribers trigger based systems like trigger-based replication or Ricardo/Slony let selective tables and cross‑version upgrades happen but fail on large datasets where resyncing terabytes can take days to a week SAN/DRBD and VM level replication are options for full cluster copies backups remain mandatory and monitoring of WAL lag determines actual safety.

AI-written summary · about

" chapters (4)

1. 0:00Start
2. 18:31Master Master Replication
3. 23:43Reliability
4. 29:35Streaming Replication

" related talks

• 02h 26mTutorialDenish Patel · PGConf Silicon Valley 2015
• 22mSecuring Postgres with streaming replicationJan Karremans · POSETTE: An Event for Postgres 2025
• 48mReplication RefreshSimon Riggs · PostgresOpen 2013
• 52mNew Data Replication Technologies in PostgreSQLAleksandr Alekseev · HighLoad++ 2017
• 48mChoosing a Replication System for PostgreSQLViktor Egorov · HighLoad++ Moscow 2018
• 51mPostgreSQL Replication Conflicts: Avoiding PitfallsHamid Quddus Akhtar · Percona Community Live 2022
• 48mPostgreSQL Replication: 20 Pitfalls and SolutionsJulian Markwort · PostgreSQL Conference Europe 2023
• 50mMoving from MSSQL to pgSQL – High Availability and Disaster RecoveryRick Lowe · Postgres Conference Orlando 2025