Re: real multi-master replication? - Mailing list pgsql-general

From Tom Lane
Subject Re: real multi-master replication?
Date
Msg-id 2489.1173068423@sss.pgh.pa.us
Whole thread Raw
In response to Re: real multi-master replication?  (Steve Atkins <steve@blighty.com>)
List pgsql-general
Steve Atkins <steve@blighty.com> writes:
> On Mar 4, 2007, at 11:18 AM, hubert depesz lubaczewski wrote:
>> i read about some replication system for postgresql, but - as far as i
>> know there is none real multi-master replication system for
>> postgresql.

> I don't believe there is, or can be, any asynchronous multi-master
> replication system for any database that will work with all possible
> general purpose constructs.

Even more to the point: there is no universally applicable replication
solution.  If something such as the OP asks for existed, its overhead
would be so extreme that hardly anyone would use it for real-world
cases.  So compromise is always the order of the day.

> Given that, you might need to be more specific about your
> needs (and rethink your application architecture based on the
> reality of the issue),

Exactly.

            regards, tom lane

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: real multi-master replication?
Next
From: Naz Gassiep
Date:
Subject: Query timing