It is very, very common to have asynchronous replication. I would say the need for synchronous is far more limited (although greater desired).

I would imagine that multi-master synchronous replication would be fairly trivial to implement with 2PC and wal-shipping available, no?

Trivial? I would say... no. There is a reason it hasn't been done yet, and a reason why CMD (for example) has zero plans to even try.

Sincerely,

Joshua D. Drake



--

   === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
   Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

Reply via email to