Re: PostgreSQL in the press again

Thomas Hallgren wrote:
> Master + read-only slaves:
>   - Slony-I when all sites are trusted
>   - dbMirror for untrusted slaves and/or table based master slave
> assignment - Mammoth Replicator, proprietary ???
>   - erServer ???

That begs the question in turn why there are so many master/slave
replication solutions.  I mean, I don't care, but this categorization
doesn't really answer the original question.

> Multi-master:
>   - C-JDBC, Will be transaction safe once PostgreSQL has XA
>   - pgPool, not transaction safe ???

These are not multimaster solutions in the sense that you can write to
any one of multiple hosts.  In a sense, they are really master/slave
solutions with the program components distributed differently.  To
write, you always have to go through one host.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/