<div dir="ltr"><span style="font-size:12.8px">Found the issue, slony cannot be upgraded directly from 2.0.7 to 2.2.5. It needs to be upgraded to 2.1.4 first and then upgraded again to 2.2.5. It configured the trigger correctly.</span><br><div class="gmail_extra"><br><div class="gmail_quote">On Mon, May 22, 2017 at 9:41 PM, Vick Khera <span dir="ltr"><<a href="mailto:vivek@khera.org" target="_blank">vivek@khera.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><span class=""><br><div class="gmail_quote">On Sat, May 20, 2017 at 5:24 AM, Soni M <span dir="ltr"><<a href="mailto:diptatapa@gmail.com" target="_blank">diptatapa@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>The upgrade went well, except it configure the trigger wrong.</div><div><br></div><div>On master, It has triggers : logtrigger, truncatedeny, and truncatetrigger</div><div>disabled trigger : denyaccess</div><div><br></div><div><div>On slave, It has triggers : denyaccess, truncatedeny, and truncatetrigger</div><div>disabled trigger : logtrigger</div></div><div></div></blockquote></div><br></span>How were the triggers configured before the upgrade? Why do you think these are wrong?</div><div class="gmail_extra"><br></div></div>
<br>______________________________<wbr>_________________<br>
Slony1-general mailing list<br>
<a href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.<wbr>info</a><br>
<a href="http://lists.slony.info/mailman/listinfo/slony1-general" rel="noreferrer" target="_blank">http://lists.slony.info/<wbr>mailman/listinfo/slony1-<wbr>general</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div>Regards,</div><div><br></div>Soni Maula Harriz</div></div>
</div></div>