On Thu, Apr 30, 2009 at 4:24 AM, Vick Khera <vivek at khera.org> wrote:
> On Wed, Apr 29, 2009 at 5:16 PM, JAY J JANSSEN <JJANSSEN at nmtransfer.com> wrote:
>> If I issue the slonik command:
>> SUBSCRIBE SET (ID=1, PROVIDER=1, RECEIVER=3, FORWARD=yes);
>> will this replace the subscription between Nodes 2 and 3 (which is what I
>> want) or will it replace the subscription between Nodes 1 and 2 (which is
>> what I don't want)?
>
> It will do what you want: replace the 2->3 replication with a 1->3
> replication, leaving the 1->2 alone.
>
> You probably want "FORWARD=no" to save some overhead.  You can do the
> same for node2 by just re-running the subscribe set for it and setting
> FORWARD=no there as well.

This isn't recommended. From the SUBSCRIBE SET docs:

    """There is, however, a case where having forwarding turned off
opens up a perhaps-unexpected failure condition; a rule of thumb
should be that all nodes that connect directly to the origin should
have forwarding turned on. Supposing one such "direct subscriber" has
forwarding turned off, it is possible for that node to be forcibly
lost in a case of failover. The problem comes if that node gets ahead
of other nodes."""

And if none of your subscribers are forwarders, you can't failover for
disaster recovery.
-- 
Stuart Bishop <stuart at stuartbishop.net>
http://www.stuartbishop.net/