How Patroni Addresses the Problem of the Logical Replication Slot ...
At a high level PostgreSQL supports two main types of replication - streaming/physical and logical ... You can read more about logical replication basics in Data To Go: Postgres Logical Replication.
How to gain insight into the pg_stat_replication_slots view by ...
postgres=# SELECT slot_name, spill_txns, spill_count, spill_bytes FROM pg_stat_replication_slots; -[ RECORD 1 ]------- slot_name | mysub spill_txns | 1 spill_count | 7 spill_bytes | 396000.
Working with PostgreSQL Replication Slots | Simplified Guide
libdata=# CREATE SUBSCRIPTION financials CONNECTION 'dbname=libdata user=postgres host=172.17.0.2' PUBLICATION financials; NOTICE: synchronized table states NOTICE: created replication slot "financials" on publisher CREATE SUBSCRIPTION.
