Tutorial
summary
Claims that PostgreSQL 9.4 removes the need for external replication tooling by combining pg_basebackup and streaming with replication slots, a simple recovery.conf trigger for failover, and continuous archiving via pg_receivewal archiving to an S3 or backup server. Demo shows setting max_replication_slots, creating named slots, seeing active LSNs, and doing a live failover; one pragmatic tuning note: some sites end up with very large wal_keep_segments (I saw 10,000 wal_keep_segments as a real example). Overall the built-in flow works in the live demo.
AI-written summary · about
chapters (8)
- 0:00Introduction to replication
- 4:56WAL internals
- 15:54Evolution of replication
- 21:24Setting up replication
- 34:35Archiving and backups
- 49:34Replication slots
- 1:12:51Hands-on implementation
- 2:09:21Failover and monitoring
related talks
49mPostgreSQL Replication - The Most Exciting Technology on Earth
48mPostgreSQL Replication: 20 Pitfalls and Solutions
22mSecuring Postgres with streaming replication
22mPostgreSQL Disaster Recovery Fundamentals
50mMoving from MSSQL to pgSQL – High Availability and Disaster Recovery
51mPostgreSQL Replication Conflicts: Avoiding Pitfalls
52mNew Data Replication Technologies in PostgreSQL
37mFailover Slots in PostgreSQL-17: