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.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> 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.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
>> http://lists.slony.info/mailman/listinfo/slony1-general
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20160519/082e1559/attachment.htm