From: | Mischa Sandberg <mischa(dot)sandberg(at)telus(dot)net> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Jeff Davis <jdavis-pgsql(at)empires(dot)org>, "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org> |
Subject: | Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item. |
Date: | 2005-04-25 00:04:21 |
Message-ID: | 1114387461.426c34053047b@webmail.telus.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-docs |
Quoting Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>:
> Mischa Sandberg wrote:
> > 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.
Forgive my kibitz, then; perhaps my head has been stuck in sand a
while. You're right, I forgot about the nicer bits of Sybase
RepServer. Synchronous replication was scratched early in the project,
because two-phase commit took too long across a dozen db servers.
Pgreplicator advertises itself as a "store-and-forward asynch replica
(sic) engine." (quoth http://pgreplicator.sourceforge.net/ )
--
"Dreams come true, not free." -- S.Sondheim, ITW
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-04-25 01:30:15 | pgsql: Remove support for OR'd indexscans internal to a single IndexScan |
Previous Message | User Andrewsn | 2005-04-24 23:40:26 | newsysviews - newsysview: start a list of stuff that could usefully be |
From | Date | Subject | |
---|---|---|---|
Next Message | Olleg Samoylov | 2005-04-25 10:31:19 | Re: BUG #1610: rewrite rule and sequence |
Previous Message | Bruce Momjian | 2005-04-24 23:24:36 | Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item. |