[Bucardo-general] General questions on Bucardo 4.8

[Greg Sabino Mullane]

On Fri, Feb 17, 2012 at 08:48:45AM -0500, jtkells wrote:
> replication tools I have tried. I was surprised to see that during one
> of my configuration attempts I decided to clean everything out (remove
> sync, remove herd, remove tables and databases) and found that the
> triggers and indexes were still setup on the tables. This is quickly
> removed but was wonder why they should remain?  Do I need to do
> something in bucardo_ctl to remove them?

This is a safety measure, as there could still be other syncs accessing 
those tables, and on triggers means a window of not catching changes.
The canonical way is to simply drop the triggers manually, or just drop 
the bucardo schema to remove everything. Ideally someone would write a 
tool/function to remove such things, and make an interface to bucardo_ctl 
for it.

> Also, I will be moving Bucardo to production shortly and will need to 
> document its processes in regards to the database and schema's Buracdo uses.  
> Is there any architecture overview  or overall processing flow that 
> Bucardo uses at the database object level that I can review and use?  

I think there are some things on the wiki and perhaps a blog post or two, 
but no overall architectural overview. At this point, I doubt there will 
be one written for Bucardo 4, but we will try to get one written for 
Bucardo 5.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20120217/2fa9f953/attachment.bin