As far as I experienced, the 'turning key' is when the sync is added
to bucardo. So what I usually start with is, dumping the source data
base, writing it to the second master or slave, add the sync (after
taking care of the db connection, tables, relgroup, etc) and be happy :)
When you want to change e.g. the type of sync, you remove the sync
from bucardo, carry out a 'drop schema bucardo cascade' to remove the
triggers in your target database and add the sync again.
Make sure that if you first set-up the sync and then dump the database
that you do not dump the bucardo scheme so that the bucardo scheme of
your source database does not get copied to the target. Bucardo takes
care of these 'client bucardo tables'.
On Tue, 11 May 2021 at 12:05, Lucas Possamai <[email protected]> wrote:
Hello,
I tried to find this information online but I couldn't find a proper
answer.
The steps I usually take are:
1. Add bucardo to my source db (add db, add table, add sequence, etc)
2. Dump the database
3. Import the database into the target db
4. start bucardo
Is that order correct? What if I dump the DB first and then add bucardo to
my source db, will bucardo know where it needs to replicate from?
... or it doesn't matter the order of the steps, as Bucardo will compare
every single row in the source and target and will replicate what's
missing?
----- Ende der Nachricht von Lucas Possamai <[email protected]> -----
_______________________________________________
Bucardo-general mailing list
[email protected]
https://bucardo.org/mailman/listinfo/bucardo-general
