Hi, Steve. I believe all of the triggers / schema were created with slony 2.2.1. Also we're currently on postgresql 9.3.5.
Mike [image: Clutch Holdings, LLC] <http://www.clutch.com> Mike James | Manager of Infrastructure 267.419.6400, ext 204 | 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. On Thu, May 19, 2016 at 2:27 PM, Steve Singer <st...@ssinger.info> wrote: > 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
