<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">--- On <b>Fri, 12/18/09, tamanna madaan <i><tamanna.madan@globallogic.com></i></b> wrote:<br><br>>From: tamanna madaan <tamanna.madan@globallogic.com><br>>Subject: [Slony1-general] logtrigger/denyaccess triggers removed from master/slave<br>>To: slony1-general@lists.slony.info<br>>Cc: "Gaurav Katiyar" <gaurav.katiyar@globallogic.com><br>>Date: Friday, December 18, 2009, 1:02 PM<br>
<div id="yiv557967693">><br><p><font size="2">>Hi All<br>
><br>
>I am using postgres-8.1.2 and slony-1.1.5 for replication.<br>
>I have 1 master and 1 slave in my cluster.<br>
>Sometimes I see problem of missing logtriggers and denyaccess triggers<br>
>on master table and slave tables respectively. Replication don't take place in that<br>
>state though systems are properly shown as master and slave.<br>
>This problem is resolved by dropping the schema used by slony on both the systems an<br>
>then recreating the schema.<br>
<br>>I want to know what could be the root cause of logtriggers/denyaccess<br>
>triggers getting removed from the tables.<br>
<br>>Thanks in advance<br>
<br>
>Regards<br>>Tamanna<br>
</font>
</p>
</div><br><br><br>The version of slony you are using <font size="2">--> slony-1.1.5 is most probably the cause.<br>It is a very old version. I highly recommend you upgrade to the latest version of 1.2.<br></font><br><div id="RTEContent"><font size="4"><span style="font-weight: bold; font-family: arial; color: rgb(0, 0, 255);">Melvin Davidson </span></font><br><br></div></td></tr></table><br>