Re: Is it safe to transfer logical replicationpublication/subscription?

On 2020-01-08 23:55, Mike Lissner wrote:
> That's a great point, thanks. The DROP SUBSCRIPTION notes say you can:
> 
>> Disassociate the subscription from the replication slot by executing ALTER SUBSCRIPTION ... SET (slot_name = NONE).
Afterthat, DROP SUBSCRIPTION will no longer attempt any actions on a remote host.
 
> 
> I'll read some more about the replication slots themselves (I did read
> about them a while back), but doing the above seems like a good way to
> break B from A, before resubscribing C to A instead?

Yes, that's the one you want.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services