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

[Juned Khan]

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
>>
>
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com
>



-- 
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20140428/0561ef1a/attachment-0001.html>