Kacey Holston kacey.holston at pgexperts.com
Tue Oct 9 12:15:27 PDT 2018
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 


More information about the Slony1-general mailing list