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@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general

Reply via email to