A proposal to force-drop replication slots to make disabling async

To proceed in this situation, first disable the subscription by executing ALTER SUBSCRIPTION DISABLE , and then disassociate it from the replication slot by

After you complete your testing, drop the replication slot you created by running: -d postgres --slot test_slot --drop-slot Notes and limitations

postgresql drop replication slot By themselves, replication slots occupy very little disk space They just store tiny bit of metadata, including a pointer to a position in WAL

postgresql create replication slot PostgreSQL Hackers pgsql-hackerslistspostgresqlorg>