PostgreSQL Logical Replication Gotchas

A Guide to Logical Replication and CDC in PostgreSQL postgresql create replication slot Replication allows a client to receive a continuous stream of updates from a PostgreSQL database, providing a near-realtime view of all changes as they occur postgresql replication slot PostgreSQL 10 came with the welcome addition of the logical replication feature This provides a more flexible and easier means to replicate

postgresql drop replication slot SELECT * FROM pg_replication_slots to see if any replication slots were accidentally created that might be preventing WAL cleanup · SHOW