[Bucardo-general] Support for SQL COPY

Adam Wendt thelsdj at gmail.com
Thu Mar 5 17:50:35 UTC 2009


Attached are patches that add optional support to use COPY to transfer all
changes to a temporary table and then use single UPDATE and/or INSERT to
modify the original table.

This has proved essential for us to  keep our databases in sync even if we
run a large UPDATE or a bunch of INSERTs and have bucardo working over a
WAN.

I don't personally use multiple column primary keys or binary pkeys but I
tried to keep those features by copying the existing code.

To enable the feature change sql_copy setting to 1 in bucardo_config.

Thanks,

Adam
Adam Wendt Consulting
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20090305/5c31f928/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sql_copy1.patch
Type: application/octet-stream
Size: 12270 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20090305/5c31f928/attachment.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sql_copy2.patch
Type: application/octet-stream
Size: 685 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20090305/5c31f928/attachment-0001.obj 


More information about the Bucardo-general mailing list