Evolution Of PostgreSQL Replication and High Availability (upto ~ 99.999%)

on YouTube ↗50m

" summary

Claims Postgres‑BDR® can deliver 99.999% availability, supports rolling upgrades, and provides automatic DDL replication while running as an active‑active mesh. The talk names alternatives (Bucardo, SymmetricDS, Quest Shareplex, Oracle GoldenGate, EDB replication server), describes a platinum architecture with PG Bouncer HAProxy logical standby shadow master witness and Barman backups managed by TPAexec, and argues BDR replaces Oracle RAC in cloud and on‑prem scenarios with demonstrated failover and upgrade workflows.

AI-written summary · about

" chapters (9)

1. 0:00Start
2. 6:33Evolution in Postgres replication and thus High availability
3. 14:13Bucardo Functionality
4. 19:21EDB Postgres Replication Server
5. 20:03EDB Replication Server Functionality
6. 21:45Oracle GoldenGate Functionality
7. 23:55Postgres Native Logical Replication
8. 33:03Postgres-BDR-Always On Platinum
9. 43:51Postgres BDR and Oracle RAC

" related talks

• 46mDeploying Maximum HA Architecture With PostgresDenish Patel · Postgres Open 2012
• 55mHigh Availability with PostgreSQL and PacemakerShaun M. Thomas · Postgres Open 2012
• 34mMassive Multi-node setup with Postgres and BDR in Retail SystemJulyanto Sutandang · FOSSASIA Summit 2017
• 50mMoving from MSSQL to pgSQL – High Availability and Disaster RecoveryRick Lowe · Postgres Conference Orlando 2025
• 49mPostgreSQL Replication - The Most Exciting Technology on EarthEdward Snajder · Open Source Bridge 2013
• 47mPostgreSQL High Availability: The Considerations and the CandidatesHamid Quddus Akhtar · Percona Live 2022
• 57mReliability features in Postgres ProLeonid Albrekht · PGConf India 2025
• 36mDesigning Layered High‑Availability Architectures for PostgreSQL on a BudgetUmair Shahid · SREcon26 Americas