Hi P,

Thanks for the info. I will pass this onto my company decision makers and see whether we like to "renew" the interest.

Thanks, \Tommy

On Sat, 2008-05-10 at 14:27 +0200, Pierangelo Masarati wrote:

Tommy Ho wrote:

...

I was wondering if anyone had success with using multi-master replication (syncrepl with mirrormode enabled) using postgresql as the backend?

I had this working using BDB but when I switched over to use postgres as the backend, the synchronization becomes very erratic and inconsistent, deleted data from one master never gets propagated and newly added data will sometimes get sync'd and sometimes it doesn't.

As far as I remember, sync replication support for back-sql was very experimental, and it broke at some stage of syncrepl development. So the fact you see an erratic behavior is as much as you could expect. I'd rather expect that no replication occurs at all. Patches are welcome, as usual, but I don't believe right now there's much interest in having that feature work as intended. It was pursued at some point relying on some customer's request which was never formalized; as such, interest in that very specialized development reduced, and no one seems to be willing to restore it. A renewed interest might boost its development, though.

p.

Ing. Pierangelo Masarati OpenLDAP Core Team

SysNet s.r.l. via Dossi, 8 - 27100 Pavia - ITALIA http://www.sys-net.it

---

Office: +39 02 23998309 Mobile: +39 333 4963172 Email: pierangelo.masarati@sys-net.it

---