[Bucardo-general] question regarding decommissioning bucardo

[Paul Theodoropoulos]

Most excellent, thank you kindly, David.

On 5/14/18 12:30, David Christensen wrote:
> Hi Paul,
>
> Bucardo leaves the delta tables and triggers around as a precaution, 
> and so you could tinker with syncs via add/drop table without losing 
> data once setup.
>
> You can safely remove those triggers/delta tables.  You’ll want to 
> remove the triggers first, then drop the tables.
>
> Best,
>
> David
>
>> On May 14, 2018, at 1:52 PM, Paul Theodoropoulos <paul at anastrophe.com 
>> <mailto:paul at anastrophe.com>> wrote:
>>
>> Several years ago I implemented bucardo to sync between two 
>> locations, for both our "PRE" environments, and "Production" 
>> environments. It's worked dandy for us.
>>
>> However, the sync of the PRE environment is rather pointless at this 
>> juncture, it was where I built it all out, but it serves no useful 
>> purpose.
>>
>> I ran the assorted bucardo commands to remove the syncs, relgroups, 
>> db's, etc etc. But....there's some leftovers - lots of leftovers, 
>> that take up precious disk space, and that I'd like to get rid of, e.g.:
>>
>>
>> trumgr_group=#
>> relation                 | total_size
>> -----------------------------------------+------------
>>  bucardo.delta_public_group_stats | 4453 MB
>>  bucardo.delta_public_unit_monthly_stats | 43 MB
>>  bucardo.delta_public_group_daily_stats | 3656 kB
>> bucardo.track_public_group_stats        | 1504 kB
>>  bucardo.delta_public_units | 528 kB
>>  bucardo.delta_public_group_weekly_stats | 312 kB
>>  bucardo.bucardo_delta_names | 216 kB
>>  bucardo.delta_public_customer_features | 200 kB
>>  bucardo.delta_public_unit_history_91 | 176 kB
>>
>> etc etc
>>
>> and there's also hundreds of triggers left behind as well. Is it safe 
>> to just drop those bucardo tables and triggers? Is there an order I 
>> should do it in?
>> -- 
>> Paul Theodoropoulos
>> www.anastrophe.com
>> _______________________________________________
>> Bucardo-general mailing list
>> Bucardo-general at bucardo.org <mailto:Bucardo-general at bucardo.org>
>> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>
> --
> David Christensen
> End Point Corporation
> david at endpoint.com <mailto:david at endpoint.com>
> 785-727-1171
>
>
>

-- 
Paul Theodoropoulos
www.anastrophe.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180514/bd97d891/attachment-0001.html>