29.2. Subscription # 29.2.1. Replication Slot Management 29.2.2. Examples: Set Up Logical Replication 29.2.3. Examples: Deferred Replication Slot Creation A subscription …| PostgreSQL Documentation
29.10. Security # The role used for the replication connection must have the REPLICATION attribute (or be a superuser). If the …| PostgreSQL Documentation
29.4. Row Filters # 29.4.1. Row Filter Rules 29.4.2. Expression Restrictions 29.4.3. UPDATE Transformations 29.4.4. Partitioned Tables 29.4.5. Initial Data Synchronization …| PostgreSQL Documentation
29.7. Restrictions # Logical replication currently has the following restrictions or missing functionality. These might be addressed in future releases. The …| PostgreSQL Documentation
29.12. Quick Setup # First set the configuration options in postgresql.conf: wal_level = logical The other required settings have default values …| PostgreSQL Documentation
29.1. Publication # A publication can be defined on any physical replication primary. The node where a publication is defined is …| PostgreSQL Documentation
29.9. Monitoring # Because logical replication is based on a similar architecture as physical streaming replication, the monitoring on a publication …| PostgreSQL Documentation
29.3. Logical Replication Failover # To allow subscriber nodes to continue replicating data from the publisher node even when the publisher …| PostgreSQL Documentation
29.6. Conflicts # Logical replication behaves similarly to normal DML operations in that the data will be updated even if it …| PostgreSQL Documentation
29.11. Configuration Settings # 29.11.1. Publishers 29.11.2. Subscribers Logical replication requires several configuration options to be set. Most options are relevant …| PostgreSQL Documentation
29.5. Column Lists # 29.5.1. Examples Each publication can optionally specify which columns of each table are replicated to subscribers. The …| PostgreSQL Documentation
Chapter 26. High Availability, Load Balancing, and Replication Table of Contents 26.1. Comparison of Different Solutions 26.2. Log-Shipping Standby Servers 26.2.1. Planning …| PostgreSQL Documentation
29.8. Architecture # 29.8.1. Initial Snapshot Logical replication starts by copying a snapshot of the data on the publisher database. Once …| PostgreSQL Documentation