Le 16/01/2015 04:59, Greg Sabino Mullane a écrit :
On Fri, Jan 09, 2015 at 12:01:29PM +0100, sym39 wrote:
-One machine "A" with one database that already have data, some
clients regularly fill the database
-Another machine "B" with the same database schema, all tables
empty, nobody fills the database
It sounds like what you need is a multi-source sync, in which the
conflict resolution doesn't matter, as nobody will be writing to B.
So you want something like this:
bucardo add sync foobar relgroup=myrels dbs=A:source,B:source
To initially populate B, you should setup Bucardo first, so that
the bucardo triggers on A are in place, then use pg_dump plus
psql to bulk copy the data from A to B. Something like:
pg_dump -h A mydb --data-only | psql mydb -h B
Once A comes back up, all the changes that accumulated on B
will be copied by Bucardo onto A.
Ok, so it is best to "manually" fill the content of the database instead
of trying to rely on
bucardo to do this.
In other words, doing something like this is a bad idea:
1. bucardo add sync foobar relgroup=myrels dbs=A:source,B:target
2. wait / check the state of the sync / other
3. bucardo update sync foobar dbs=A:source,B:source
Is it plan to implement the onetimecopy for multiple source mode to make
bucardo do this kind of work under the covers?
Thanks and regards,
Sylvain
_______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
