[Bucardo-general] Helping to understand delta update

[Tommi Savikko]

Answering to my self:

On sync, there is checktime (interval) which controls this.

This was not updateable with
bucardo update sync <syncname> checktime

So I updated the table sync with

UPDATE sync SET checktime=INTERVAL '30 seconds' where name='<syncname>';

Now it works.

________________________________
From: Bucardo-general <bucardo-general-bounces at bucardo.org> on behalf of Tommi Savikko via Bucardo-general <bucardo-general at bucardo.org>
Sent: Friday, 8 November 2024 18.36
To: bucardo-general at bucardo.org <bucardo-general at bucardo.org>
Subject: [Bucardo-general] Helping to understand delta update

Hi!

I have been evaluating Bucardo and so far it looks great, thanks!

Case which I have here has n nodes, and one "main" database, but all nodes should act as a master.

First I thought I could implement this running one centralized bucardo instance, but as those nodes are sometimes offline, it seems that bucardo will stop syncing if node is down.

So, now i have bucardo running on every node, and those always have dbgroup, having local database and main database and then sync with makedelta=1.

Now, when I update data on node A, it updates right away to main.

Also, when up update data on main, it updates right away from main to node A and node B.

But, making change to node A only gets to node B when:

  *
bucardo is restarted
  *
there is some other change on main

So my question is that is there some polling interval or so, which controls the delta updates?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20241108/b27cdd6b/attachment-0001.htm>