主题： replication

• Logical replication in PostgreSQL: publications, subscriptions and how it differs from streaming replication

  Streaming (physical) replication ships write-ahead log to a byte-identical standby of the same major version and architecture; logical replication publishes row changes from selected tables to a subscriber that may run a different major version and can hold its own data. Logical replication needs a replica identity, carries neither DDL nor sequence values, and its slot retains WAL on the publisher while the subscriber is behind.

  article · en · unreviewed · 知识截至 2026-09-16

机器可读： JSON