Get started with logical replication

Logical replication enables replicating data from your Neon database to external destinations, allowing for Change Data Capture (CDC) and real-time analytics. Stream your data to data warehouses, analytical database services, messaging platforms, event-streaming platforms, external Postgres databases, and more.

Logical replication in Neon works like it does on any standard Postgres installation. It uses a publish and subscribe model to replicate data from the source database to the destination.

Replication starts by copying a snapshot of the data from the publisher to the subscriber. Once this is done, subsequent changes are sent to the subscriber as they occur in real-time.

To get started, jump into one of our step-by-step logical replication guides.

To learn more about Postgres logical replication, see Learn about logical replication.

Logical replication guides

• 

  Airbyte

  Replicate data from Neon with Airbyte

  Learn more
• 

  Bemi

  Create an automatic audit trail with Bemi

  Learn more
• 

  ClickHouse

  Replicate data from Neon to ClickHouse (DoubleCloud)

  Learn more
• 

  Fivetran

  Replicate data from Neon with Fivetran

  Learn more
• 

  Kafka

  Replicate data from Neon with Kafka (Confluent)

  Learn more
• 

  Materialize

  Replicate data from Neon to Materialize

  Learn more
• 

  Postgres

  Replicate data from Neon to PostgreSQL

  Learn more

Show more

Learn about logical replication

• Logical replication concepts

  Learn about Postgres logical replication concepts

• Manage logical replication

  Learn how to manage logical replication in Neon