On Mon, 05 Nov 2012 08:32:54 -0500 Sergey Okhapkin <sos@sokhapkin.dyndns.org> wrote:
Does Postgres support circular multi-master replication like mysql does?
You have several solutions, depending whether you want sync (a bit of weakness her) or async: PGCluster, Bucardo, Postgres-R, RubyRep... (http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pool...) EnterpriseDB is also presenting a solution (xDB), but it is in a beta state though. AFAIK, the most achieved sync project is Postgres-XC (See http://postgres-xc.sourceforge.net/ & http://en.wikipedia.org/wiki/Multi-master_replication#PostgreSQL) and Rubirep for async, (http://www.rubyrep.org/) - open-source speaking of course, 'cos there are other (proprietary) solutions.
Are there some ways to run geographically distributed DB cluster?
As far as you can partition and sync replicate, you can do that with Pg. -- If it takes a bloodbath, lets get it over with. No more appeasement. -- Ronald Reagan