Tue Oct 9 12:15:27 PDT 2018
- Previous message: [Slony1-general] Understanding resubscribe
- Next message: [Slony1-general] Understanding resubscribe
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Thank you for your reply, I want to make sure I am absolutely clear before using the call on a production system so I have two questions.
1. Currently C is a receiver of A, do I still need to use
RESUBSCRIBE NODE (
ORIGIN = A,
PROVIDER = A,
RECEIVER = C
);
Current:
A ------—> B
\__> C ——>D
Desired:
A ————>C ————>D
\_____>B
2. Calling resubscribe node as below will only change B’s provider on all sets and leave all other nodes as they are, is that correct?
RESUBSCRIBE NODE (
ORIGIN = A,
PROVIDER = C,
RECEIVER = B
);
Thank you,
Kacey
> On Oct 8, 2018, at 2:47 PM, Steve Singer <steve at ssinger.info> wrote:
>
> On Mon, 8 Oct 2018, Kacey Holston wrote:
>
>> I have not had to use the resubscribe command since migrating to 2.2 and I am not quite understanding the
>> docs. I am hoping someone can clarify how to use the call for me.
>> I have 4 nodes
>> A is replicating to B and C and C is replicating to D.
>> I would like to resubscribe B so it is a receiver from C so A is the provider to C and C is the provider to
>> B and D.
>> Would I run:
>> RESUBSCRIBE NODE (
>> ORIGIN = A,
>> PROVIDER = C,
>> RECEIVER = B
>> );
>> And it will resubscribe all the sets? What id I wanted to only resubscribe some sets? There does not seem to
>> be an option for this like there was with using subscribe set(). I see the function for reshapesubscription
>> which seems to be more in line with what I want but it does not seem to be a callable.
>
> I think you would first need to do
>
> RESUBSCRIBE NODE (
> ORIGIN = A,
> PROVIDER = A,
> RECEIVER = C
> );
>
> So C is receiving the data from A directly
>
> then you could do
>
> RESUBSCRIBE NODE (
> ORIGIN = A,
> PROVIDER = C,
> RECEIVER = B
> );
>
> to point B at C.
>
> If all your sets have A as the origin then they must all take the same route
> to each subscriber. You can't have some sets from A reach C through B and other sets from A reach C directly.
>
>
>
>> Any guidance would be greatly appreciated.
>> — Kacey
>>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info <mailto:Slony1-general at lists.slony.info>
> http://lists.slony.info/mailman/listinfo/slony1-general <http://lists.slony.info/mailman/listinfo/slony1-general>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20181009/39b1c682/attachment.htm
- Previous message: [Slony1-general] Understanding resubscribe
- Next message: [Slony1-general] Understanding resubscribe
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list