[Bucardo-general] question regarding decommissioning bucardo
Paul Theodoropoulos
paul at anastrophe.com
Mon May 14 18:52:45 UTC 2018
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180514/b5e43fa7/attachment.html>
More information about the Bucardo-general
mailing list