It worked just like you said it would, exactly what I needed.

Thank you for the help.
Jay J. 

-----Original Message-----
From: Vick Khera [mailto:vivek at khera.org] 
Sent: Wednesday, April 29, 2009 4:24 PM
To: JAY J JANSSEN
Cc: slony1-general at lists.slony.info
Subject: Re: [Slony1-general] Revising Subscriptions

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.