Re: [Gnumed-devel] database replication with bucardo

[Slappinjohn]

Hi


>>      ref | loinc_staging
>>      ref | atc_staging 
> 
> Those need not be replicated. They are staging tables. Can
> Bucardo ignore tables ?

Bucardo just replicates the tables you want it to replicate, so yes.


>> however one thread poster commented that the above had
>> failed to list out tables whose (only) constraint was a
>> foreign key reference.
> 
> Which is not wanted here either because a foreign key
> constraint need not be unique.
> 
> So I guess we are in good shape.

I can't completely agree. As it seems bucardo will only replicates
tables with pushdelta method who have a primary key. Even if there are
unique keys you'll have to use a fullcopy method. So the setup is a
little more complicated as I thought before.

e.g. bucardo complains about all the audit.log* tables for not having a
primary key -- I think they need to be replicated, aren't they?

Marc