[Bucardo-general] Having problem with setting master master replication

[Juned Khan]

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 at 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 <jkhan6722 at gmail.com> 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 <jkhan6722 at gmail.com> 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 <greg at endpoint.com>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 at 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 greg at endpoint.com
>>> End Point Corporation
>>> PGP Key: 0x14964AC8
>>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20140428/88e8b3cc/attachment.html>