On 05/17/2016 02:59 PM, Mike James wrote: > 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) > > In the database when I "select * from pg_trigger; " I see some triggers > from the older, unused schemas, particularly _logtrigger, > _truncatetrigger have tgenabled = O. > > _denyaccess and _truncatedeny are disabled (tgenabled = D) > > 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,
What version of slony is are the old schema's based on? Depending on the version this makes a difference on how you would remove them. Steve > > Mike > Clutch Holdings, LLC <http://www.clutch.com> Mike James | Manager of > Infrastructure > 267.419.6400, ext 204 | mike.ja...@clutch.com <mailto:mike.ja...@clutch.com> > 201 S Maple St. | Suite 250 | Ambler, PA 19002 > Clutch.com <http://www.clutch.com> | Twitter > <https://twitter.com/clutchsuccess> | LinkedIn > <https://www.linkedin.com/company/2837209> | YouTube > <https://www.youtube.com/user/clutchsuccess> | Clutch Support Center > <http://clientsupport.clutch.com/> > > The only end to end consumer management platform that empowers > consumer-focused businesses to identify, target, message, and engage > their best customers. > > > > _______________________________________________ > Slony1-general mailing list > Slony1-general@lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general > _______________________________________________ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general
