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 <[email protected]
<mailto:[email protected]>> 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
[email protected] <mailto:[email protected]>
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
--
David Christensen
End Point Corporation
[email protected] <mailto:[email protected]>
785-727-1171
--
Paul Theodoropoulos
www.anastrophe.com
_______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
