Re: do I need replication or something else?

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: do I need replication or something else?
Date: 2005-03-30 03:33:57
Message-ID: m3oed17qoq.fsf@knuth.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Centuries ago, Nostradamus foresaw when caleb(at)vetstar(dot)com (Caleb Simonyi-Gindele) would write:
> John Burger wrote:
>>>> If it were me, and someone proposed a model where two-way
>>>> replication was needed, I would tell them to rethink their model.
>>>> It's broken.
>>>
>>> I would respectfully disagree that the requirement for two-way
>>> replication indicates a broken design.
>>
>>
>> I agree with your disagreement. This design is present in lots of
>> non-RDB systems - CVS, IMAP, PDA syncing, etc. It's clearly more
>> complicated, but can be made to work, and has been many times. I
>> don't see anything about databases in general, or Postgres
>> specifically, that indicates it's a bad idea.
>>
>> - John D. Burger
>> MITRE
>>
> Yes, we use it successfully with the SQL Server edition of our
> product. Does anyone know if this is available with Postgre?

There's no such thing as "Postgre," so there's a paucity of features
available for that...

If you're thinking of PostgreSQL, the only system I am aware of that
offers a similar form of "highly asynchronous multi master with
conflict avoidance/resolution" is PeerDirect's replication system.
--
let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];;
http://linuxdatabases.info/info/slony.html
"Python's minimalism is attractive to people who like minimalism. It
is decidedly unattractive to people who see Python's minimalism as an
exercise in masochism." -- Peter Hickman, comp.lang.ruby

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ken Johanson 2005-03-30 03:47:15 Re: Possible to run the server with ANSI/ISO string
Previous Message Dale Sykora 2005-03-30 03:26:54 Re: sub query constraint