Re: replication between US <-> EU - Mailing list pgsql-general

From Ondrej Ivanič
Subject Re: replication between US <-> EU
Date
Msg-id CAM6mie+as=ZN2UMs=inTKTE-RnEe18yZ93ym+cwWWW9V8M=VSg@mail.gmail.com
Whole thread Raw
In response to Re: replication between US <-> EU  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Hi,

On 7 March 2012 10:36, John R Pierce <pierce@hogranch.com> wrote:
> On 03/06/12 3:31 PM, Ondrej Ivanič wrote:
>>
>> - one side completely down: Client should use switch to other side
>> transparently (Failover / High Availability)
>
>
> what happens if the link between the sites is down and both sides decide
> they are master?  then how do you put the pieces back together ?

Good catch! From application point of it is quite easy to sync data
between sites. Let's assume that writes should be disabled in this
scenario.

--
Ondrej Ivanic
(ondrej.ivanic@gmail.com)

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Single server multiple databases - extension
Next
From: Matteo Sgalaberni
Date:
Subject: Re: corrupted table postgresql 8.3