[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