logical replication slots

AMBIL SEKARANG

PostgreSQL Replication Slots

In simpler terms, logical replication in PostgreSQL is a way to copy data from one database to another in a more flexible and customizable manner compared to physical replication.

PostgreSQL: Documentation: 17: 47.2. Logical Decoding Concepts

47.2. Logical Decoding Concepts # 47.2.1. Logical Decoding 47.2.2. Replication Slots 47.2.3. Replication Slot Synchronization 47.2.4. Output Plugins 47.2.5. Exported Snapshots …

PostgreSQL Replication Guide: Navigate Complexity | Airbyte

Property max_replication_slots should be greater than zero for logical replication, because logical replication can’t work without replication slot.

An Overview of Logical Replication in PostgreSQL | Severalnines

target_rep=# 2018-03-21 16:16:42.207 IST [24618] LOG: logical replication apply worker for subscription "mysub" has started 2018-03-21 16:16:42.217 IST [24619] ...