4.2 Using Logical Replication

Logical replication is an asynchronous feature that allows data modification to be transferred from a source (publisher) to a target system (subscriber) across different PostgreSQL database versions. It provides more granular control over the data copied and is useful during an upgrade.

Advantages of Logical Replication

• It allows you to replicate only specific tables, rather than the entire database.
• You can create replicas with different database schemas by using a transformation layer between publisher and subscriber.
• It allows you to perform a live upgrade, avoiding the downtime of your database.

Learn more from the following resources:

• @official@Logical Replication
• @youtube@PostgreSQL Logical Replication Guide