[Bucardo-general] Question about order of the Bucardo setup

[IT Technical Analyst FOD]

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 <bucardo-general-bounces at bucardo.org> On Behalf Of Lucas Possamai
Sent: martedì 11 maggio 2021 02:14
To: bucardo-general at bucardo.org
Subject: Re: [Bucardo-general] Question about order of the Bucardo setup

On Tue, 11 May 2021 at 12:05, Lucas Possamai <drum.lucas at gmail.com<mailto:drum.lucas at gmail.com>> 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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210511/8f8cdba8/attachment.htm>