<div dir="ltr"><div class="gmail_extra"><div><br></div><div class="gmail_quote">On 27 June 2014 16:55, 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">
<p dir="ltr">I guess you mean either UNSUBSCRIBE SET or DROP NODE.</p>
<p dir="ltr">What should happen in the UNSUBSCRIBE case is that the node quickly confirms all the outstanding events since they no longer require replicating any data, at which point all providers can perform/finish log switching again. </p>
<p dir="ltr">In the case of DROP NODE the behavior is similar. Make sure that ALL remaining nodes in the cluster have forgotten everything about the dropped node before attempting to rebuild it. Or rebuild it with a different node ID.</p>
<p dir="ltr">If this is your only node, then you could as well uninstall the whole cluster and start from scratch.<br><br></p></blockquote><div><br></div><div>Yes I did mean UNSUBSCRIBE SET. And I forgot to mention this is slony 1.2</div>
<div><br></div><div>Also as is usually the case it is not as simple as I have first posed. For reasons that I won't elaborate the lagging subscription is a duplicate of one that is not lagging.</div><div><br></div><div>
One of the sl_log_x files is 16G in size. </div><div><br></div><div>Suggestions are welcome</div><div><br></div><div>Dave Cramer</div><div><br></div><div><a href="http://www.credativ.ca">www.credativ.ca</a></div><div><br>
</div><div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="gmail_quote"><div><div class="h5">On Jun 27, 2014 4:04 PM, "Dave Cramer" <<a href="mailto:davecramer@gmail.com" target="_blank">davecramer@gmail.com</a>> wrote:<br type="attribution"></div></div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
<div dir="ltr">If I drop the subscription through drop set will the log file be automagically cleaned up ?<div><br></div><div>If not how can I fix it ?</div><div><br clear="all"><div>Dave Cramer</div>
</div></div>
<br></div></div>_______________________________________________<br>
Slony1-general mailing list<br>
<a href="mailto:Slony1-general@lists.slony.info" target="_blank">Slony1-general@lists.slony.info</a><br>
<a href="http://lists.slony.info/mailman/listinfo/slony1-general" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
<br></blockquote></div>
</blockquote></div><br></div></div>