From: | Mike Lissner <mlissner(at)michaeljaylissner(dot)com> |
---|---|
To: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Is it safe to transfer logical replication publication/subscription? |
Date: | 2020-01-09 20:11:50 |
Message-ID: | CAMp9=EwrOG0Q1Xyzvmf2QparjZbEXp7b74qyaJe=9zKpGSUCVA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you Peter, this is wildly helpful.
On Thu, Jan 9, 2020 at 7:52 AM Peter Eisentraut
<peter(dot)eisentraut(at)2ndquadrant(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | github kran | 2020-01-09 20:47:26 | Re: Upgrade PostgreSQL 9.6 to 10.6 |
Previous Message | Matthias Apitz | 2020-01-09 19:20:56 | ESQL/C FETCH of CHAR data delivers to much data for UTF-8 |