Hi greg, That error is fixed, i think with newer version name of tables is changed i have used pgbench_history instead of history but next step gave me below error.
root@juned:~# bucardo_ctl add sync benchdelta source=alpha targetdb=test2 type=pushdelta Failed to add sync: DBD::Pg::st execute failed: ERROR: insert or update on table "sync" violates foreign key constraint "sync_targetdb_fk" DETAIL: Key (targetdb)=(test2) is not present in table "db". at /usr/local/bin/bucardo_ctl line 3362. https://mail.endcrypt.com/pipermail/bucardo-general/2009-October/000451.html from above thread i came to know that i need grant permission in db table, but i don't know where to find this tables. bucardo table contains nothing. please suggest. Regards Juned Khan On Mon, Apr 28, 2014 at 10:51 AM, Juned Khan <[email protected]> wrote: > 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 >>> >>
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
