[Bucardo-general] Sync databases with existing data

[Laurent GARCES]

Hi Greg,

That's what we were thinking...
Thanks.

Regards,

-- 
Laurent GARCES
LRD www.l-rd.fr
+33 (0)4 67 92 52 56

Le 25/02/2015 19:49, Greg Sabino Mullane a écrit :
> 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.
>