<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>Revising Subscriptions</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">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:</FONT></P>
<P><FONT SIZE=2 FACE="Arial"> Node 1 --> Node 2 --> Node 3. </FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">We used the following to set it up: </FONT>
<BR><FONT SIZE=2 FACE="Arial">SUBSCRIBE SET (ID=1, PROVIDER=1, RECEIVER=2, FORWARD=yes);</FONT>
<BR><FONT SIZE=2 FACE="Arial">SUBSCRIBE SET (ID=1, PROVIDER=2, RECEIVER=3, FORWARD=yes);</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I want to change this so that Node 1 provides to both Nodes 2 and 3, and I'd like to do </FONT>
<BR><FONT SIZE=2 FACE="Arial">it so that we don't have to reload Node 3 from scratch (there's about 80 GB of data in the tables).</FONT>
<BR><FONT SIZE=2 FACE="Arial">The data should flow like this: </FONT>
<BR><FONT SIZE=2 FACE="Arial"> Node 3 <-- Node 1 --> Node2 </FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">If I issue the slonik command:</FONT>
<BR><FONT SIZE=2 FACE="Arial">SUBSCRIBE SET (ID=1, PROVIDER=1, RECEIVER=3, FORWARD=yes);</FONT>
<BR><FONT SIZE=2 FACE="Arial">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)? </FONT></P>
<P><FONT SIZE=2 FACE="Arial">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.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Jay Janssen </FONT>
</P>
</BODY>
</HTML>