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 logical r...  
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.