Damián Bakarcic dbakarcic at mecon.gov.ar
Wed Sep 3 07:20:04 PDT 2008
Vivek Khera escribió:
>
>
> On Tue, Sep 2, 2008 at 11:04 AM, Damián Bakarcic 
> <dbakarcic at mecon.gov.ar <mailto:dbakarcic at mecon.gov.ar>> wrote:
>
>     Hi,
>     I´m relatively new to slony and I needed help to configure it in
>     order to satisfy the following conditions:
>     I have four nodes, 1-4, and two replication sets, A-B. B is a
>     subset of A. Node 1 is the master and node 2 subscribes to 1 to
>     replicate set A. Nodes 3 and 4 both subscribe to node 2 but i
>     don´t need them to replicate all of the tables in set A, only the
>     ones in the subset B.
>     Am I supposed to create set B with node 1 as origin and only
>     subscribe nodes 3 and 4 to set B in node 2?. To do this, is it
>     necessary to also subscribe node 2 to 1 to replicate set B when
>     set A already includes the tables in set B?.
>     Thanks in advance.
>
>
> The tables can only be in one set.  Since B is a subset of A, your 
> node 2 should subscribe to both sets A and B, and your nodes 3 & 4 
> should subscribe to just set B.
>  
>
Thanks for the help, but, you tell me that the tables can only be in one 
set, so I understand that A and B cannot have the same origin node. Is 
this correct?. If they actually can have the same origin node, would it 
cause trouble to replicate both sets, whose intersection is not empty, 
between nodes 1 & 2?.
Is there another way to do this?, for instance, can I "only" replicate 
set A between nodes 1 & 2 and somehow replicate only part of that set 
(subset B exactly) between sets 2 & 3 and 2 & 4.
Thanks again.
Damian.



More information about the Slony1-general mailing list