Re: [Gnumed-devel] database replication with bucardo

[Slappinjohn]

> 
> That means you are saying "I will never need to access both
> work and home at the same time". Good to know because it'll
> ease up on the requirements.
> 

this could change, because my wife is starting to do my writing stuff at
home so parallel access could be possible, that's why I'll give bucardo
a try (tested rubyrep before -- didn't got it workin')

> 
> OK, good. That means you don't need to replicate the audit
> table data because when Bucardo replays the SQL on the
> "other" database it will invoke the audit triggers anyways.
> 
> The only question now is whether Bucardo will replay every
> single change or whether it will replay the "latest version"
> only in case there would have been several generations of a
> row.
> 

Bucardo does a trigger based replication, so is nearly on time.

Marc