Skip to content
masterclass Buddy
Start learning

PostgreSQL · Concept

Logical replication

Logical replication copies selected PostgreSQL data from a publisher to subscribers. It starts with existing data, then continuously sends later changes while preserving commit order within a subscription.

Last updated

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • Publication
  • Subscription
  • Replica identity
  • Row filters
  • Column lists
  • Logical replication failover
  • Initial snapshot
  • WAL

Source: PostgreSQL: Documentation: 18: Chapter 29. Logical Replication. Checked 2026-11-03.