[Bucardo-general] must specify a primary key when using a sync of 'pushdelta' at line 263.

Rosser Schwarz rosser.schwarz at gmail.com
Wed Dec 23 20:45:44 UTC 2009

On Wed, Dec 23, 2009 at 1:16 PM, akp geek <akpgeek at gmail.com> wrote:

> does that mean that I have to have primary key defined on every table in the
> database inorder to replicate?

Every table you want to replicate using a delta or swap sync, yes.
Bucardo uses the primary key to track rows that have changed, and
hence will need to be replicated to the sync's target databases.
Fullcopy syncs don't require a pkey, as the entire table is replicated
each time they're run.

Multi-column keys are supported.



More information about the Bucardo-general mailing list