[Bucardo-general] Bucardo 5.4 replication with 2db with no primary key in some tables
Greg Sabino Mullane
greg at endpoint.com
Tue Sep 29 14:28:27 UTC 2015
On Fri, Sep 04, 2015 at 10:16:51AM -0300, Marcelo M. Martins (M3 System) wrote:
> I need to replicate 2 dbs (dbs1 source master and dbs2 dest slave )
> with postgresql 9.4.1 with bucardo 5.4, but the db1 have some tables
> with no primary key and bucardo stop in the validate process.
> How can I use bucardo in this situation ?
The best solution is to give those tables a primary key (or a unique index).
It is far more efficient to only copy the rows that have changed than
to have to copy the entire table every time the sync runs.
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 163 bytes
Desc: Digital signature
More information about the Bucardo-general