暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
文档 / A lesser known Superpower of Postgres Logical Replication: Protocol Versions.pdf
A lesser known Superpower of Postgres Logical Replication: Protocol Versions.pdf
张凡
10
30页
0次
6天前
5墨值下载
A lesser known superpower of
Postgres Logical Replication:
Protocol Versions
Kevin Biju, Engineering @ClickHouse
Introduction
https://github.com/PeerDB-io/peerdb
2
Overview of Postgres replication methods
● Postgres relies on WAL (write-ahead log) for transaction durability; all changes
(even uncommitted ones!) are written to disk as part of a WAL file
● Log-shipping moves entire WAL files from the primary to the standby using an out
of band process (archive_command/restore_command)
● Streaming replication moves individual WAL records over a connection between
primary and standby (walsender/walreceiver)
● Since there is minimal processing of these WAL files, both these methods are relatively
simple and pretty reliable. A lot of HA/replica setups use them.
● Since WAL is global, can’t control what changes you want to replicate.
https://www.postgresql.org/docs/current/warm-standby.html
3
of 30
5墨值下载
postgresql
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

相关文档

PostgreSQL : Page Buffer Overview.pdf
3浏览
pgAdmin安装.pdf
4浏览
Failover Slots in PostgreSQL-17: Ensuring High Availability with Logical Replication.pptx
3浏览
Postgresql 10 Administration Cookbook - 2018 - Packt.pdf
5浏览
PostgreSQL Query Performance Monitoring for the Absolute Beginner.pdf
5浏览
Packt-PostgreSQL 14 Administration Cookbook-2022.pdf
15浏览

评论