<div dir="ltr"><div class="gmail_quote">Hi Glyn,</div><div class="gmail_quote"><br><br><div dir="ltr">I am trying to set up a totally separate cluster for DB2 -> DB3 :<span class=""><div><br></div><div><div style="font-family:arial,sans-serif;font-size:13px">Cluster1 -> replicating from DB1 to -> DB2</div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">Cluster2 -> replicating from DB2 to -> DB3</div></div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">Granthana</div></span></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Oct 9, 2014 at 6:10 PM, Glyn Astill <span dir="ltr"><<a href="mailto:glynastill@yahoo.co.uk" target="_blank">glynastill@yahoo.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
<br>
<br>
<br>
<br>
>________________________________<br>
> From: Granthana Biswas <<a href="mailto:granthana.biswas@gmail.com" target="_blank">granthana.biswas@gmail.com</a>><br>
>To: <a href="mailto:slony1-general@lists.slony.info" target="_blank">slony1-general@lists.slony.info</a><br>
>Sent: Thursday, 9 October 2014, 13:18<br>
>Subject: [Slony1-general] Error with Slony replication from another slony cluster slave<br>
<div><div>><br>
><br>
><br>
>Hi All,<br>
><br>
><br>
>I am trying to replicate from another Slony cluster's slave node.<br>
><br>
><br>
>Cluster1 -> replicating from DB1 to -> DB2<br>
><br>
><br>
>Cluster2 -> replicating from DB2 to -> DB3<br>
><br>
><br>
>The initial sync up went fine without any errors. There are no errors in logs of both the clusters. Also no st_lag_num_events in DB3 or DB2 for Cluster2.<br>
><br>
><br>
>But the data added in DB2 since I started slony Cluster2 is not reflecting in DB3.<br>
><br>
><br>
>Does slony allow replication from another cluster's slony slave? Or did I miss something?<br>
><br>
><br>
<br>
</div></div>Perhaps you could show us what you've done so far, to me it's unclear if you are setting up a totally seperate slony cluster for DB2->DB3, or just trying to subscribe DB3 to sets in the existing cluster.<br>
<br>
<br>
If it's the latter, then as long as the slave you want to use as the provider was subscribed to the sets you want with "FORWARD = YES" it should be ok<br>
<br>
<br>
See: <a href="http://main.slony.info/documentation/stmtsubscribeset.html" target="_blank">http://main.slony.info/documentation/stmtsubscribeset.html</a><br>
<br>
You should be able to check by looking at sub_forward in sl_subscribe, some thing like:<br>
<br>
select * from _<cluster name>.sl_subscribe where sub_receiver = <id of DB2>;<br>
<div><div><br>
>Thanks & Regards,<br>
>Granthana Biswas<br>
><br>
><br>
</div></div></blockquote></div><br></div>
</div></div></div><br></div>