Failed to add sync: DBD::Pg::st execute failed: ERROR: Table "public.pgbench_history" must specify a primary key when using a sync of 'pushdelta' at line 263. at line 30.
I have set primary key manually for this table is it fine to do this ? On Mon, Apr 28, 2014 at 10:50 AM, Juned Khan <[email protected]> wrote: > Hi, > > $ bucardo_ctl add all tables db=opensips -T history --herd=alpha --verbose > New tables: > public.accounts > public.branches > public.tellers > New tables added: 46 > Already added: 0 > > $ bucardo_ctl add all tables db=opensips -t history --herd=beta --verbose > Sorry, no tables were found > > Here the output of second command is different it should be something like > > New tables: > public.history > New tables added: 1 > Already added: 0 > > > > On Sun, Apr 27, 2014 at 11:55 PM, Greg Sabino Mullane > <[email protected]>wrote: > >> On Fri, Apr 25, 2014 at 04:49:03PM +0530, Juned Khan wrote: >> > > "public.pgbench_history" must specify a primary key when using a sync >> of >> > > 'pushdelta' at line 263. at line 30. >> ... >> > it seems its primary ley related error but i don't know how to fix this. >> >> Did you use the -T flag as described on that page? What was the output of >> the "add all tables" command? >> >> > i have also tried to setup master master replication using below link. >> > >> http://justatheory.com/computers/databases/postgresql/bootstrap-bucardo-mulitmaster.html >> > >> > but there i am getting problem with creating dbgroup >> > >> > > root@juned:~# bucardo_ctl add dbgroup mydbs $PGDATABASE:source >> > > $PGDATABASE:source >> > > No matching databases found >> >> $PGDATABASE is a variable - you need to define it, or just manually enter >> the >> name of the database as you added it with the "add db" command. >> >> -- >> Greg Sabino Mullane [email protected] >> End Point Corporation >> PGP Key: 0x14964AC8 >> > > > > -- > Thanks, > Juned Khan > iNextrix Technologies Pvt Ltd. > www.inextrix.com > -- Thanks, Juned Khan iNextrix Technologies Pvt Ltd. www.inextrix.com
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
