Bruce Momjian <[EMAIL PROTECTED]> writes: > From our previous discussion of 2-phase commit, there was concern that > the failure modes of 2-phase commit were not solvable. However, I think > multi-master replication is going to have similar non-solvable failure > modes, yet people still want multi-master replication.
No. The real problem with 2PC in my mind is that its failure modes occur *after* you have promised commit to one or more parties. In multi-master, if you fail you know it before you have told the client his data is committed. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings