[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:
> 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>

More information about the Bucardo-general mailing list