Hi everyone, I need help here. I am currently using this version https://github.com/bucardo/bucardo Basically, I will have branch sync data to HQ. My replication works fine, no more error on primary key after i exclude the nopk-table. I tried these commands below. bucardo installbucardo add database dbleft dbname=branchdbbucardo add database dbright host=192.168.1.12 dbname=hqdbbucardo add all tables -T nopk-table herd=therdbucardo add all sequences herd=therdbucardo add dbgroup tgroup dbleft:source dbright:targetbucardo add sync foobar herd=therd dbs=tgroup ping=falsebucardo startbucardo kick foobarbucardo statusbucardo stopbucardo start Now I have a new problem. I have no idea how to solve this. FYI, project table has only 1 primary key which is ID. UserID is the foreign key. Note, I am using an open source system which has the db design. If I change the db design, I will screw up the whole system. Branch - project table------------------------------ID | UserID | Project---------------------------1 | John | A2 | John | B3 | John | C HQ - project table------------------------ID | UserID | Project---------------------------1 | Susan | X2 | Susan | Y When I sync branch to HQ, then I will have the latest results as below. HQ - project table------------------------------ID | UserID | Project---------------------------1 | John | A2 | John | B3 | John | C How come Susan's data are all gone? It's all overwritten by John? I believe it is due to the same primary key which probably Bucardo updates them. Is there a way when replication from branch to HQ for this project table, it will auto-increment new ID instead of replacing them? Or based on ID and UserID? By right, I should have these data for HQ. HQ - project table (but i doubt this will work due to ID as the only pk)------------------------------ID | UserID | Project---------------------------1 | John | A1 | Susan | X2 | John | B2 | Susan | Y3 | John | C or at least this HQ - project table------------------------------ID | UserID | Project---------------------------1 | John | A2 | John | B3 | John | C4 | Susan | X5 | Susan | Y But I need to do some kind of real time replication sync? else, I am not sure how does bucardo smart enough to assign 4 and 5 to susan. Note: RubyReps doesn't have this problem. Why? When you enable streaming replication, for dbleft the primary key will be auto-increment based on odd number. For dbright, it will auto increment on even number. Just I can't figure out how-to solve this on bucardo 5. Any help? Thanks in advance.
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
