New Data Replication Technologies in PostgreSQL

on YouTube ↗52m

" summary

Overview of PostgreSQL replication and auto-failover capabilities, including new features introduced in PostgreSQL 10. Covers types of replication and the problems they solve, how to configure streaming replication and logical replication, and how to set up auto-failover/HA using Stolon and Consul. After the talk attendees will be able to configure PostgreSQL replication and auto-failover themselves.

AI-written summary · about

" chapters (16)

1. 0:00Introduction
2. 3:12Why replication
3. 10:17Replication types in PostgreSQL
4. 13:53Streaming replication
5. 18:56Streaming replication limits
6. 20:42Logical replication in PostgreSQL 10
7. 24:14Why logical replication
8. 27:15Logical replication limits
9. 35:03Logical decoding mechanism
10. 36:49Failover for physical replication
11. 37:50Failover for logical replication
12. 41:04Managing streaming replication
13. 42:30PostgreSQL 10 new features
14. 43:34Sharding and distributed transactions
15. 45:52Upgrading PostgreSQL via replication
16. 47:25Q&A

" related talks

• 49mPostgreSQL Replication - The Most Exciting Technology on EarthEdward Snajder · Open Source Bridge 2013
• 48mChoosing a Replication System for PostgreSQLViktor Egorov · HighLoad++ Moscow 2018
• 48mPostgreSQL Replication: 20 Pitfalls and SolutionsJulian Markwort · PostgreSQL Conference Europe 2023
• 48mReplication RefreshSimon Riggs · PostgresOpen 2013
• 50mMoving from MSSQL to pgSQL – High Availability and Disaster RecoveryRick Lowe · Postgres Conference Orlando 2025
• 02h 26mTutorialDenish Patel · PGConf Silicon Valley 2015
• 51mPostgreSQL Replication Conflicts: Avoiding PitfallsHamid Quddus Akhtar · Percona Community Live 2022
• 53mThe journey towards active replication in PostgreSQLJonathan S. Katz, Amit Kapila · PGCon 2023