JAY J JANSSEN JJANSSEN at nmtransfer.com
Wed Apr 29 14:16:23 PDT 2009
We are using Slony1 1.2.15 installed on 3 nodes and all of the
replicating tables are defined in one set. Currently we are set up so
that Node 1 is the Master, Node 2 is the receiver from Node 1, and Node
3 is the receiver from Node 2. So the data flows like this:
   Node 1 --> Node 2 --> Node 3.  

We used the following to set it up:   
SUBSCRIBE SET (ID=1, PROVIDER=1, RECEIVER=2, FORWARD=yes);
SUBSCRIBE SET (ID=1, PROVIDER=2, RECEIVER=3, FORWARD=yes);

I want to change this so that Node 1 provides to both Nodes 2 and 3, and
I'd like to do 
it so that we don't have to reload Node 3 from scratch (there's about 80
GB of data in the tables).
The data should flow like this:  
    Node 3 <-- Node 1 --> Node2       

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)? 

I couldn't find a reference to this in the archives, if it does exists
please point me to it.  Any help or insight into this would be
appreciated.  Thanks.
Jay Janssen 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090429/984fb7b1/attachment.htm


More information about the Slony1-general mailing list