On Sat, Dec 23, 2023
If you already have a replication created with a replication slot, then, you can clean restore_command and primary_conninfo settings on replica, reload configuration of the replica, and then remove the leftover replication slot from the master. For example:
- on replica
- alter system set primary_conninfo to '';
- alter system set restore_command to '';
- select pg_reload_conf();
- on master
- select pg_drop_replication_slot('ron_replication_slot1');
Excellent. Thank you