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

Physical slots are created automatically based on replica hosts and used for data replication within the Managed Service for PostgreSQL cluster

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

postgresql 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 drop replication slot If due to network breakdown or some other error, PostgreSQL is unable to remove the slots, an error will be reported To proceed in this situation, the user