Skip to content

Explanations

Understand how ETL works and why

Where to Start

New to Postgres logical replication? Start with Postgres Replication Concepts. It explains WAL, publications, replication slots, and why ETL works the way it does.

Already familiar with replication? Jump to Architecture to understand ETL's two-phase approach and delivery guarantees.

All Topics

  1. Postgres Replication Concepts: The fundamentals - WAL, publications, slots, pgoutput, and why two phases.

  2. Architecture: How ETL works - initial copy, streaming, workers, and delivery guarantees.

  3. Event Types: All events your destination receives - Insert, Update, Delete, Begin, Commit, and their fields.

  4. Extension Points: The traits you implement - Destination, SchemaStore, StateStore, CleanupStore.

Next Steps

When you're ready to build, head to the Guides.