[Bucardo-general] Does bucardo_delta_targets need any maintenance
Greg Sabino Mullane
greg at endpoint.com
Wed Oct 16 02:37:48 UTC 2013
On Tue, Oct 15, 2013 at 07:28:15PM +0000, Markova, Nina wrote:
> I would like to know what is the purpose of table
'bucardo_delta_targets' as I didn't find any info on web .
>
> Does the table need any maintenance ?
It should not. Its purpose is to list which syncs are replicating
from which tables. Because more than one sync can potentially
operate on a table, we cannot clean the delta tables until we
know that the rows in question have been replicated by every
sync using that table. Since a sync has no way of knowing about
other syncs, we defer that cleanup and use the bucardo_delta_targets
table to coordinate between them.
It should be a small table, and contain a single entry for
each sync/table combination you are using. If it has duplicates
or other wrong information, just manually clean it out.
--
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20131015/59ca3fc6/attachment.sig>
More information about the Bucardo-general
mailing list