Logical replication | Postgres.FM 063 |

[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]

Nikolay and Michael discuss logical replication — some history, initialization, change data capture, how to scale it, some limitiations, and ways that it is getting better.

Here are some links to some things they mentioned:

* Logical replication https://www.postgresql.org/docs/curre...
* GitLab upgraded multi-terabyte, heavily-loaded clusters with zero-downtime   / 1700574156222505276  
* pg_waldump https://www.postgresql.org/docs/curre...
* pg_dump and external snapshots (blog post by Michael Paquier) https://paquier.xyz/postgresql-2/post...
* Failover of logical replication slots in Patroni (talk by Alexander Kukushkin)    • Alexander Kukushkin. Failover of logi...  
* Our episode on replication https://postgres.fm/episodes/replication


~~~


What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov   / samokhvalov   and @michristofides   / michristofides  


~~~


Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
- Michael Christofides, founder of pgMustard https://pgmustard.com/


~~~


This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.