Hello again, sorry, only now I see this question of yours: “... 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? “
No, Bucardo works setting triggers on replicated tables. When someone or something modifies a row in a table under replication, the trigger will insert a “delta” record in a table created by bucardo. When the sync is kicked (by default there is autokick, so by itself) bucardo applies that delta to the target db. But if the dbs are not identical before the moment you add that db to bucardo, he will not replicate what’s missing, only the changes that occur from that moment and recorded by the trigger. Bye again, Mattia From: Bucardo-general <[email protected]> On Behalf Of Lucas Possamai Sent: martedì 11 maggio 2021 02:14 To: [email protected] Subject: Re: [Bucardo-general] Question about order of the Bucardo setup On Tue, 11 May 2021 at 12:05, Lucas Possamai <[email protected]<mailto:[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?
_______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
