On 05/19/2016 03:26 PM, Mike James wrote:
> 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.
>

I think you should be able to just drop the other slony schema's with 
cascade and it should clean everything up.



> Mike
>
> Clutch Holdings, LLC <http://www.clutch.com>		Mike James | Manager of
> Infrastructure
> 267.419.6400, ext 204 | mike.james at clutch.com <mailto:mike.james at 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 <steve at ssinger.info
> <mailto:steve at 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 <tel:267.419.6400%2C%20ext%20204> |
>         mike.james at clutch.com <mailto:mike.james at clutch.com>
>         <mailto:mike.james at clutch.com <mailto:mike.james at 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 at lists.slony.info
>         <mailto:Slony1-general at lists.slony.info>
>         http://lists.slony.info/mailman/listinfo/slony1-general
>
>
>
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>