Re: Does Version 9.1 Streaming Replication Supports Multi-Master?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Does Version 9.1 Streaming Replication Supports Multi-Master?
Date: 2012-01-17 20:18:55
Message-ID: 4F15D7AF.9000302@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 01/17/12 12:10 PM, Jerry Richards wrote:
>
> I know PostgreSQL version 9.1 supports built-in streaming
> replication. Just wondering if that supports only a single-master or
> also multi-master implementation?
>

master -> readonly slave only.

Master-Master replication is a giant can of worms, with thorny issues of
conflict resolution that can't be resolved in a general case without
massive performance impacts.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tim Uckun 2012-01-17 20:25:23 Re: Does Version 9.1 Streaming Replication Supports Multi-Master?
Previous Message Jerry Richards 2012-01-17 20:10:35 Does Version 9.1 Streaming Replication Supports Multi-Master?