Julian Scarfe julian
Fri Jun 11 06:55:35 PDT 2004
From: "Jeff" <threshar at torgo.978.org>

> > If nodes 2 and 3 are both slaves of node 1, what paths and listen
> > entries should I establish?
>
> All nodes need paths and listen's for each other. This can get a bit
> tedious if you have a lot of slaves (Someday we'll have a tool to make
> it easy).  I run slony with 5 slaves and it does fine.
>
> so if you have nodes 1,2,3
> you need listens from 1-2, 1-3,  2-1,  2-3,  3-1,  3-2
> and paths of the same.

Thanks for that.  I'd thought that was the way I had it.

Since there were some problems with the list earlier in the week, I emailed
Jan directly and was pointed at the slony_setup.pl perl script.  That works
for the situation.  While I had:

    store listen ( origin = 1, provider = 1, receiver = 2 );
    store listen ( origin = 2, provider = 2, receiver = 1 );
    store listen ( origin = 1, provider = 1, receiver = 3 );
    store listen ( origin = 3, provider = 3, receiver = 1 );
    store listen ( origin = 2, provider = 2, receiver = 3 );
    store listen ( origin = 3, provider = 3, receiver = 2 );

the perl script produced:

    store listen ( origin = 1, provider = 1, receiver = 2 );
    store listen ( origin = 2, provider = 2, receiver = 1 );
    store listen ( origin = 1, provider = 1, receiver = 3 );
    store listen ( origin = 3, provider = 3, receiver = 1 );
    store listen ( origin = 2, provider = 1, receiver = 3 );
    store listen ( origin = 3, provider = 1, receiver = 2 );

Note the origin != provider for 2<->3.

Can someone explain (or point me to the bit of the doc that explains) the
topology required please?

Julian Scarfe




More information about the Slony1-general mailing list