A comprehensive guide to managing Postgres replication slots in production CDC pipelines, covering WAL bloat prevention, heartbeat configuration, table-level publications, column and row filters, failover slots (Postgres 17), replica identity FULL, monitoring with Prometheus/Grafana, and housekeeping practices. Based on real-world experience with Debezium's Postgres connector, but principles apply broadly to any logical replication consumer.
Sort: