[Bucardo-general] removing a sync and triggers - help

[Michelle Sullivan]

Alex Balashov wrote:
> On 09/13/2013 03:08 PM, Markova, Nina wrote:
>
>>     Note: table triggers (if any) are not automatically removed!
>> Do I need to do anything else? I have sync1 and sync3 doing the same job
>> as sync5, but independently .
>> Do I need to remove any triggers? Which? How to find them?
>
> You can see the bucardo triggers on each table in the Postgres CLI by
> doing: \d <table name>
>
> The easiest way to get rid of them all at once is:
>
>    DROP SCHEMA bucardo CASCADE;
>
> -- Alex
>

Not good advice if they are still running some syncs (as was suggested
in the first email) as this will remove everything bucardo from the
database.

The triggers will have to be removed manually for any defunct syncs.

Michelle

-- 
Michelle Sullivan
http://www.mhix.org/