[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.
Best,
David
> 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
785-727-1171
-------------- 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