I think this problem is because i am not replicating sequences so sequences are not updating and as result when i am trying to add rows from another master its trying to start from first. in that case its giving duplicate error.
So i think i should check with adding sequence too. it doesn't work and i can go with odd even sequence solution. On Wed, May 14, 2014 at 12:11 PM, Rosser Schwarz <[email protected]>wrote: > On Tue, May 13, 2014 at 11:13 PM, Juned Khan <[email protected]> wrote: > >> Thanks for the answer, if i use this command to add all tables then >> sequence will be added automatically for replication ? >> >>> bucardo add all tables db=master1 herd=mherd >> >> > That command will only add *tables* to the things Bucardo knows to > replicate. The bucardo command also has an "add all sequences" operation, > which you should not perform for your scenario. > > with live database whenever first master will go down then second master >> db will be used for write process, how do i manage that with sequence ? >> > > Both databases should have all of your tables and sequences, but Bucardo > should be configured to replicate only the tables. > > On db1, you then set the sequences to issue only *odd* numbers. ("ALTER > SEQUENCE foo START 1 INCREMENT 2;" — produces 1, 3, 5...) > > On db2, you set them to issue only *even* numbers. ("ALTER SEQUENCE foo > START 2 INCREMENT 2;" — produces 2, 4, 6...) > > > > -- > :wq > -- Thanks, Juned Khan iNextrix Technologies Pvt Ltd. www.inextrix.com
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
