[Bucardo-general] overlapping master/slave replication, and rules on the slave

Nick Farrell nicholas.farrell at gmail.com
Mon Mar 22 06:21:11 UTC 2010

I've looked over the Bucardo documentation, and am not sure whether a 
particular configuration is supported. What would happen if I ran 
multiple instances of Bucardo, each one replicating a different remote 
database to a single central database?

The scenario involves a layout where I know that each record in a table 
is 'owned' by one of the remote databases, but I'd like the changes 
replicated centrally.

As only the slave is overlapping, I'm hoping there's no namespace 
collision, and the record-level updates will interleave smoothly. While 
I'm happy to go ahead and just try this out, I thought it worth finding 
out whether it was theoretically possible first.

And my second question:
How are rules treated? I see that indexes are not propogated across - 
what happens with rules? I assume they are not copied across, and if 
COPY is being used to update the tables, I believe the rules will not be 
invoked. Am I correct?

Thanks for your help.

More information about the Bucardo-general mailing list