[Bucardo-general] update only replica

Joshua Tolley josh at endpoint.com
Mon Aug 31 17:52:22 UTC 2009


On Sat, Aug 29, 2009 at 11:30:06PM +1000, Grant Maxwell wrote:
>    Hi
>    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 ?
>    The reason I want this is that for a specific (very key) table, records
>    are created and then within a minute or so are either updated with final
>    information or deleted.
>    I only want finalised records transferred.

You might be able to achieve this with a customselect option, if there's some
way to look at a particular record and tell whether or not it has been
finalized. For instance, if there's a boolean field called is_final, you might
have your customselect statement say "SELECT ... FROM table WHERE is_final".

-- 
Josh Tolley  josh at endpoint.com  801-485-0203
End Point Corporation

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20090831/7f60b74a/attachment.bin 


More information about the Bucardo-general mailing list