swap is a type of Bucardo sync in which changes to tables on two databases are exchanged both ways, in other words, a replication system where each source is also a target.
With swap syncs, the two databases are referred to as “source” and “target”, but things can flow both ways.
Because tables (and sequences) can be updated on both sides, there needs to be a way to resolve conflicts. Each table or sequence used in a swap sync must indicate how to resolve conflicts, either with standard or custom conflicts. The standard conflicts are set with the “standard_conflict” field of the goat table, and must be one of these values:
You can also provide custom conflict handlers to allow you to use business logic for better conflict resolution.
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.