Re: Is it safe to transfer logical replication publication/subscription?
Mike Lissner <[email protected]> Thu, 9 Jan 2020 12:11:50 -0800
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <CAMp9=EwrOG0Q1Xyzvmf2QparjZbEXp7b74qyaJe=9zKpGSUCVA@mail.gmail.com> |
Thank you Peter, this is wildly helpful. On Thu, Jan 9, 2020 at 7:52 AM Peter Eisentraut <[email protected]> wrote: > > 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). After that, 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