Postgres Logical Replication and Idle Databases

Delete the Replication Slot: Once you've identified the slot, you can delete it using the pg_drop_replication_slot function Replace slot_name with

To make this possible, the PostgreSQL connector follows a delete As a PostgreSQL administrator, drop the replication slot on the primary database server

postgres create logical replication slot We were able to successfully stop the PID on the primary and then drop the replication slot using SELECT pg_drop_replication_slot

postgresql create replication slot NOTICE: created replication slot my_subscription on publisher CREATE SUBSCRIPTION From now on, all INSERT , UPDATE , and DELETE