Topic: 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

Machine-readable: JSON