Debugging and Troubleshooting PostgreSQL Streaming Replication

on YouTube ↗49m

" summary

Covers PostgreSQL streaming replication (introduced 2010): why installations use it, common operational problems that arise, and how to diagnose and fix them using both built-in PostgreSQL tools and third-party utilities. Focuses on practical debugging and remediation techniques for replication issues in production environments.

AI-written summary · about

" chapters (8)

1. 0:00Introduction
2. 1:26Replication theory
3. 4:59Diagnostic tools
4. 12:51Common issues symptoms
5. 28:22pg_xlog bloat
6. 38:23Replication recovery conflicts
7. 42:38Recovery process 100% load
8. 45:06Summary

" related talks

• 51mPostgreSQL Replication Conflicts: Avoiding PitfallsHamid Quddus Akhtar · Percona Community Live 2022
• 48mPostgreSQL Replication: 20 Pitfalls and SolutionsJulian Markwort · PostgreSQL Conference Europe 2023
• 22mSecuring Postgres with streaming replicationJan Karremans · POSETTE: An Event for Postgres 2025
• 49mPostgreSQL Replication - The Most Exciting Technology on EarthEdward Snajder · Open Source Bridge 2013
• 02h 26mTutorialDenish Patel · PGConf Silicon Valley 2015
• 42mPostgreSQL Replication Conflicts: Avoiding PitfallsHamid Quddus Akhtar · PGConf NYC 2022
• 21mGetting ready for PostgreSQL 9.1Gabriele Bartolini, Marco Nenciarini, Harald Armin Massa · EuroPython 2011
• 51mPostgreSQL Replication Conflicts: Avoiding PitfallsHamid Quddus Akhtar · Percona Live 2022