# A Guide to Logical Replication and CDC in PostgreSQL with Airbyte

DevFeed: [A Guide to Logical Replication and CDC in PostgreSQL with Airbyte](<https://devfeed.tech/articles/a-guide-to-logical-replication-and-cdc-in-postgresql-with-airbyte-4933.md>)

Original publisher: [Read original article](<https://neon.com/blog/a-guide-to-logical-replication-and-cdc-in-postgresql-with-airbyte>)

Author: Jacob Prall

Published: 2024-01-11T16:04:46Z

Content type: article

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Database](<https://devfeed.tech/topics/database.md>), [Data analysis](<https://devfeed.tech/topics/data-analysis.md>), [Concurrency](<https://devfeed.tech/topics/concurrency.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [community](<https://devfeed.tech/tags/community.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [data-analysis](<https://devfeed.tech/tags/data-analysis.md>), [database](<https://devfeed.tech/tags/database.md>), [guide](<https://devfeed.tech/tags/guide.md>), [high-availability](<https://devfeed.tech/tags/high-availability.md>), [load-balancing](<https://devfeed.tech/tags/load-balancing.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [rdbms](<https://devfeed.tech/tags/rdbms.md>), [recovery](<https://devfeed.tech/tags/recovery.md>), [replication](<https://devfeed.tech/tags/replication.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

## AI overview

This guide explains logical replication and change data capture in PostgreSQL, including why data may need to be replicated between PostgreSQL servers or moved to systems suited for analysis and activation. It introduces database replication concepts, compares replication approaches, and describes PostgreSQL's Write-Ahead Log and its roles in crash recovery, point-in-time recovery, and concurrent transactions.

## Source excerpt

PostgreSQL is a database that needs no introduction. Started as an open-source project out of UC Berkeley, it has evolved through decades of careful stewardship to become one of the world's most relied on and beloved relational database management systems (RDBMS). There will inev...