<div dir="ltr">Hi, all. Due to some changes in our slony schema over the years, in our database I now see three slony schemas. Our current replication set only uses the most recent one. (slony 2.2.1 and PG 9.3)<div><br></div><div>In the database when I "select * from pg_trigger; " I see some triggers from the older, unused schemas, particularly _logtrigger, _truncatetrigger have tgenabled = O. </div><div><br></div><div>_denyaccess and _truncatedeny are disabled (tgenabled = D)</div><div><br></div><div>How do I safely remove these triggers and delete the unused slony schemas? This maybe a simple question - but I'd rather not take the chance with the production database. Thanks,</div><div><br></div><div>Mike<br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><table border="0" cellspacing="0" cellpadding="0" style="font-family:Times"><tbody><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;border-bottom-width:1px;border-bottom-color:rgb(200,200,200);border-bottom-style:solid"> </td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;height:5px"> </td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;height:5px"><table width="100%" border="0" cellpadding="0" cellspacing="0"><tbody><tr><td rowspan="2" style="font-family:'Gill Sans',Helvetica,sans-serif;line-height:20px;padding-right:10px;padding-left:10px;border-right-width:1px;border-right-color:rgb(200,200,200);border-right-style:solid"><a href="http://www.clutch.com" target="_blank"><img src="https://s3.amazonaws.com/assets.clutchwallet.com/clutchLogo.png" alt="Clutch Holdings, LLC" name="UNIQUE_ID_SafeHtmlFilter_Clutch" width="140" height="76" border="0"></a></td><td rowspan="2" style="font-family:'Gill Sans',Helvetica,sans-serif;line-height:24px;border-left-width:1px;border-left-color:rgb(200,200,200);border-left-style:solid;margin-right:10px;padding-right:20px"> </td><td style="font-family:'Gill Sans',Helvetica,sans-serif;font-size:18px;line-height:24px;border-bottom-width:1px;border-bottom-color:rgb(200,200,200);border-bottom-style:solid;padding-bottom:5px"><font color="#f16528">Mike James</font> | Manager of Infrastructure<br><span style="font-size:13px">267.419.6400, ext 204 | <a href="mailto:mike.james@clutch.com" target="_blank">mike.james@clutch.com</a></span></td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;font-size:13px;line-height:20px;padding-top:5px">201 S Maple St. | Suite 250 | Ambler, PA 19002 <br><a href="http://www.clutch.com" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">Clutch.com</a> | <a href="https://twitter.com/clutchsuccess" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">Twitter</a> | <a href="https://www.linkedin.com/company/2837209" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">LinkedIn</a> | <a href="https://www.youtube.com/user/clutchsuccess" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">YouTube</a> | <a href="http://clientsupport.clutch.com/" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">Clutch Support Center</a></td></tr></tbody></table></td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;height:5px"> </td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:12px;font-style:italic;line-height:20px;padding-right:30px;border-top-width:1px;border-top-color:rgb(200,200,200);border-top-style:solid;border-bottom-width:1px;border-bottom-color:rgb(200,200,200);border-bottom-style:solid;height:30px">The only end to end consumer management platform that empowers consumer-focused businesses to identify, target, message, and engage their best customers.</td></tr></tbody></table></div></div></div></div></div></div></div></div></div>
</div></div>