Christopher Browne cbbrowne
Thu Aug 11 18:51:57 PDT 2005
David Durham wrote:

> From the docs it looks like this is not supported by slony.  Is that
> correct?  

Correct.

> Is there anything for postgres that does support an asynchronous
> master to master replication scenario?

Rumor has it that PeerDirect has something of the sort; the model is
apparently somewhat akin to the "PalmPilot Sync", where each host is
potentially a relatively equal "peer" (hence the name!).

Sybase has a replication system that apparently works in a somewhat
similar fashion.  At some point, I could see someone taking a version of
Slony-I and "forking" it to build an async multimaster system.

One trouble case that comes up really quickly is that of the handling of
"balance" columns.  That is, things like account balances, where updates
are intended to *adjust* the balance, not to "set" the balance.  
Obvious policies for automated conflict resolution systems don't do
terribly well with account balances :-(.


More information about the Slony1-general mailing list