[Bucardo-general] Sync databases with existing data

[Greg Sabino Mullane]

On Tue, Feb 24, 2015 at 11:15:17AM +0100, Laurent GARCES wrote:
> Hi,
> 
> Is it possible to add bucardo sync to databases with already
> existing data so that they will sync?
> If we have db and db1 with existing data and then we do:
> bucardo add db db dbname=... host=... user=... password=...
> bucardo add db db1 dbname=... host=... user=... password=...
> bucardo add sync sync dbs=db:source,db1:source tables=all
> Only later modifications seem to be replicated.

No. This is on the todo list, but the only way to do it currently 
is to modify all the rows and have bucardo do it, e.g.

update table foobar set id=id

Or (better), use pg_dump to copy things from one db to the other.

-- 
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/20150225/37da3759/attachment.sig>