[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