Pipeline failure due to replication slot errors
Pipeline failure due to replication slot errors
The pg_replication_slots view provides a listing of all replication slots that currently exist on the database cluster, along with their current state For more
Replication slots were introduced in PostgreSQL to help ensure a primary PostgreSQL instance does not remove WAL files before a replica has The replication slot basically tells Postgres not to recycle or remove any WAL files that could ultimately prevent it from catching up with
elytra slot Remove all subscriptions before you remove the CDC Replication Engine for PostgreSQL instance It the subscriptions are not removed, you must drop all In mopping up on the replica side, I couldn't just drop the subscription, because it couldn't drop the nonexistent slot on the master and so refused to work