Securing Postgres with streaming replication

on YouTube ↗22m

" summary

Covers concrete setup steps: enable WAL (write-ahead logging), add a replica, and choose async vs sync with the recommended pattern of local synchronous and remote asynchronous to balance durability and latency; describes a 3-sync-standby, wait-for-2 max-availability pattern, cascading replicas and continuous WAL streaming for point-in-time recovery, and discusses RTO/RPO tradeoffs. Mentions practical tooling like Patroni, PgBouncer and HAProxy and claims streaming replication is rock‑solid and binary compatible.

AI-written summary · about

" chapters (11)

1. 0:00Introduction and agenda
2. 2:08What is streaming replication?
3. 4:53Transaction log
4. 5:59Characteristics
5. 7:22Scaling PostgreSQL safely (nearly) to infinity
6. 9:47Primary and replica
7. 10:27Async and sync
8. 16:01Primary and Cascading replicas
9. 17:55Solid foundation
10. 18:55Corollaries
11. 21:05Conclusion

" related talks

• 48mReplication RefreshSimon Riggs · PostgresOpen 2013
• 49mPostgreSQL Replication - The Most Exciting Technology on EarthEdward Snajder · Open Source Bridge 2013
• 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
• 02h 26mTutorialDenish Patel · PGConf Silicon Valley 2015
• 22mPostgreSQL Disaster Recovery FundamentalsRilwan Musa · Postgres Conference Orlando 2025
• 51mPostgreSQL Replication Conflicts: Avoiding PitfallsHamid Quddus Akhtar · Percona Community Live 2022
• 42mPostgreSQL Replication Conflicts: Avoiding PitfallsHamid Quddus Akhtar · PGConf NYC 2022