X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 2A35253F9B;
	Sun, 24 Apr 2005 20:24:53 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 15522-07; Sun, 24 Apr 2005 23:24:43 +0000 (GMT)
Received: from candle.pha.pa.us (candle.pha.pa.us [64.139.89.126])
	by svr1.postgresql.org (Postfix) with ESMTP id 1F7DF53F93;
	Sun, 24 Apr 2005 20:24:42 -0300 (ADT)
Received: (from pgman@localhost)
	by candle.pha.pa.us (8.11.6/8.11.6) id j3ONOaO26057;
	Sun, 24 Apr 2005 19:24:36 -0400 (EDT)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200504242324.j3ONOaO26057@candle.pha.pa.us>
Subject: Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.
In-Reply-To: <1114384506.426c287a87058@webmail.telus.net>
To: Mischa Sandberg <mischa.sandberg@telus.net>
Date: Sun, 24 Apr 2005 19:24:36 -0400 (EDT)
Cc: "Joshua D. Drake" <jd@commandprompt.com>,
	Jeff Davis <jdavis-pgsql@empires.org>,
	"Marc G. Fournier" <scrappy@postgresql.org>,
	Robert Treat <xzilla@users.sourceforge.net>,
	PostgreSQL-documentation <pgsql-docs@postgresql.org>
X-Mailer: ELM [version 2.4ME+ PL121 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.01 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200504/25
X-Sequence-Number: 2955

Mischa Sandberg wrote:
> Quoting Bruce Momjian <pgman@candle.pha.pa.us>: 
>  
> > Joshua D. Drake wrote: 
> > > Jeff Davis wrote: 
> > > > Should the text include a mention of synchronous vs. 
> > asynchronous? Or 
> > > > does master-master imply synchronous? 
> > >  
> > > It shouldn't. It is possible to have synchronous replication 
> > without it 
> > > being master<->master. 
> >  
> > We could mention async vs sync but at the FAQ stage I think the 
> > multi-master/master-slave disinction is enough. Let's see what 
> > questions 
> > we get. 
>  
> About all you can say is, it is not possible to implement synchronous 
> master-master replication, because of conflict resolution of 
> simultaneous transactions. 

You mean asynchronous master-master?  There are some implementations
(Sybase?, pgreplicator) that do this and have conflict resolution.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073