Re: Best way to stop Streaming Replication?

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');