Aiven for PostgreSQL®: Automatic Recreation of Replication Slots

Aiven for PostgreSQL®: Automatic Recreation of Replication Slots drop replication slot postgres The default is 10 This parameter can only be set at server start Setting it to a lower value than the number of currently existing replication slots will drop slot Replication slots were introduced with PostgreSQL and are designed to ensure that any standby connected to the primary using a replication slot will always

drop slot Currently postgres doesn't allow dropping a replication slot that's active This can make certain operations more time-consuming or stuck in production

drop em slot Use pg_drop_replication_slot : select pg_drop_replication_slot; See the docs and this blog The replication slot must be Failover of the logical replication slot​ · Configure replication slot in PostgreSQL · Wait for replication slot to be ready, then begin a transaction and export