|
From: | Slappinjohn |
Subject: | Re: [Gnumed-devel] database replication with bucardo |
Date: | Wed, 27 Jun 2012 13:11:45 +0200 |
User-agent: | Mozilla/5.0 (X11; Linux x86_64; rv:10.0.4) Gecko/20120510 Icedove/10.0.4 |
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
[Prev in Thread] | Current Thread | [Next in Thread] |