Last updated: 2020-02-28

fullcopy is a type of Bucardo sync that copies an entire table from one database (the source) to one or more target databases. Any rows on the targets are removed first, and the table is populated using the COPY command. This is the only sync that can be used for tables that have no primary key and no unique index. Because it copies the entire table every time, it is not efficient and should not be run often for large tables. It is far better in most cases to add a unique index to the table and then use a pushdelta sync to keep things up to date.

The contents of the table can be modified as they are copied over, by setting the customselect field of the sync. This should be a SELECT statement that returns some subset of the original table’s columns. It must contain at least the columns used in the primary key or unique index.

Bucardo.org is hosted and supported by End Point Dev

End Point Dev logo

Need assistance with Bucardo?

End Point Dev offers professional support for Bucardo, as well as specializing in developing, designing, and marketing effective websites. Since 1995, our diverse team of developers has shown that End Point can handle your organization’s greatest web and database challenges.