[Bucardo-general] Concurrency errors when replicating a master to two slaves and installation experiences

[gjsw]

Hi Greg,

Unfortunately I ended up giving up on Postgresql replication and Bucardo.  There were a few reasons for this, one of them being this bug and concurrency problems but the real killer for me was the lack of DDL replication.

Despite telling our DBAs many times that Bucardo needs to be updated when tables are changed, they never did this and were always puzzled when their changes failed to replicate.  Typically I'd get an email about a week after a table had been manually changed along the lines of "replication is broken but only for some fields, please fix it".  

I realise that this is because Postgresql doesn't currently support DDL triggers rather then missing functionally in Bucardo as such.  I looked at several other replication systems as well and none of them were able to offer the functionality I wanted either.

In the end I just couldn't get things working the way I wanted so I redeployed our database servers without any replication as a traditional master database server that all systems connect to and a separate identical system for testing.

Hope you are able to fix up Bucardo and good luck with the project.

Cheers,
Geoff


----- Original Message -----
From: Greg Sabino Mullane <greg at endpoint.com>
Date: Sunday, July 3, 2011 11:47
Subject: Re: [Bucardo-general] Concurrency errors when replicating a master to two slaves and installation experiences
To: Geoff Williams <gjsw at utas.edu.au>
Cc: bucardo-general at bucardo.org

> On Mon, Nov 29, 2010 at 08:43:20PM +1030, Geoff Williams wrote:
> ...
> > > > 2) There seems to be an undocumented ~20 character limit 
> to the 
> > > > length of a sync name.[...]
> ... (other problems)
> 
> Have you had a chance to try the new version yet? I'm hoping it 
> will fix all the problems you are seeing (and probably introduce 
> some new ones, ha ha!)
> 
> The git version is still in flux but settling down enough for 
> serious testing. (That goes for everyone on the list - please 
> test and post issues here or on #bucardo)
> 
> -- 
> 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/20110704/a0b97c4a/attachment.html