[Bucardo-general] Bucardo 5.4 replication with 2db with no primary key in some tables

[Greg Sabino Mullane]

On Fri, Sep 04, 2015 at 10:16:51AM -0300, Marcelo M. Martins (M3 System) wrote:
> Hi
> 
> 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...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20150929/decf8365/attachment.sig>