[Bucardo-general] question regarding decommissioning bucardo

David Christensen david at endpoint.com
Mon May 14 19:30:02 UTC 2018

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.



> On May 14, 2018, at 1:52 PM, Paul Theodoropoulos <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 <http://www.anastrophe.com/>_______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general

David Christensen
End Point Corporation
david at endpoint.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180514/aa66ffd4/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180514/aa66ffd4/attachment.sig>

More information about the Bucardo-general mailing list