<div dir="ltr"><div class="gmail_quote"><div dir="ltr"><div>Hi Jan,</div><div><br></div><div>Thanks for your quick reply!</div><div><br></div>What if DB1 goes out in future? Can I make DB2 the new origin of same cluster, i.e. master of DB3 without down time for DB2?<div><br></div><div><br></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Oct 9, 2014 at 6:00 PM, Jan Wieck <span dir="ltr"><<a href="mailto:jan@wi3ck.info" target="_blank">jan@wi3ck.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>On 10/09/2014 08:18 AM, Granthana Biswas wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi All,<br>
<br>
I am trying to replicate from another Slony cluster's slave node.<br>
<br>
Cluster1 -> replicating from DB1 to -> DB2<br>
<br>
Cluster2 -> replicating from DB2 to -> DB3<br>
<br>
The initial sync up went fine without any errors. There are no errors in<br>
logs of both the clusters. Also no st_lag_num_events in DB3 or DB2 for<br>
Cluster2.<br>
<br>
But the data added in DB2 since I started slony Cluster2 is not<br>
reflecting in DB3.<br>
<br>
Does slony allow replication from another cluster's slony slave? Or did<br>
I miss something?<br>
</blockquote>
<br></div></div>
This does not work because the logTrigger will only record information when firing in session_replication_role 'origin'. When Slony is applying changes from DB1 to DB2, the session_replication_role is 'replica', so the logTrigger action is suppressed inside the trigger function.<br>
<br>
You will have to make DB3 a member of Cluster1 and use DB2 as the data provider to achieve this. This has the added benefit that you can easily change the data provider of DB3 to DB1 in case you need to perform any maintenance on DB2.<br>
<br>
<br>
Regards,<br>
Jan<span><font color="#888888"><br>
<br>
-- <br>
Jan Wieck<br>
Senior Software Engineer<br>
<a href="http://slony.info" target="_blank">http://slony.info</a><br>
</font></span></blockquote></div><br></div>
</div></div></div><br></div>