[Bucardo-general] update only replica

Greg Sabino Mullane greg at endpoint.com
Mon Aug 31 18:01:05 UTC 2009


> I would like to have a replication rule that for a specific sync rule or
> for a specific table, only replicates record updates. Inserts and
> Deletes are not replicated. Is there an easy way to achieve this ?

Yes: Ben Allen added the bucardo_custom_trigger table, which allows
tight control of what things to store in the bucardo_delta table (and
thus get replicated). If you truly want to only do updates, you could
probably remove the trigger on the table and recreate it with only "ON
UPDATE". The validate_sync function only checks that the trigger exists,
it doesn't check when it fires, so you should be safe.

-- 
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: 226 bytes
Desc: OpenPGP digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20090831/96670d3d/attachment.bin 


More information about the Bucardo-general mailing list