'DROP EXTENSION pglogical' while an unused logical replication

'DROP EXTENSION pglogical' while an unused logical replication drop replication slot postgres It will take a while for you to create and connect to a new logical replication slot You have two choices in the meantime: either you shut down drop slot safe SELECT pg_drop_replication_slot; Replace 'slot_name' with the name of the replication slot you want to remove Clean Up:

drop slot safe I am using Postgres Debezium Source Connector for the source database on AWS RDS Sometimes, my server shutdown

drop em slot demo This simply introduces two new options allowing to create or drop a physical replication slot, respectively –create-slot and –drop-slot The catalog_xmin, xid, The oldest transaction affecting the system catalogs that this slot needs the database to retain VACUUM cannot remove catalog tuples deleted