-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Damián Bakarcic a écrit :
> 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.
> 

Hi,

What you can do, here, is create 2 different sets, A and B, with union (A,B)
containing all tables that you need to replicate.
You then subscribe 2 to A and B and 3-4 to just B.

That should do the job as expected.

- --
Stéphane Schildknecht
PostgreSQLFr - http://www.postgresql.fr
Dalibo - http://www.dalibo.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFI817ZA+REPKWGI0ERAgIaAJwJZsrSL+aHq289qxe+do8nHTIMrACfW7Ng
yBCP+9GL1rOmdeoit8MdAJs=
=uHKh
-----END PGP SIGNATURE-----