Re: Choosing PostgreSQL as the database for our next project - Mailing list pgsql-general

From William Yu
Subject Re: Choosing PostgreSQL as the database for our next project
Date
Msg-id dldbol$2uru$2@news.hub.org
Whole thread Raw
In response to Re: Choosing PostgreSQL as the database for our next project  (Johnny Ljunggren <johnny@navtek.no>)
List pgsql-general
Johnny Ljunggren wrote:
> William Yu wrote:
>
>> What I'm not sure about though is what would happen with 2 slaves if
>> main goes down AND the connection between center 1 & 2 is also
>> disconnected. Others with more experience with the various
>> master/slave replication solutions might want to chime in now on how
>> it would work.
>
>
> Well, this might be a problem, because there is no connection between
> center 1 and 2, so they will basically live their own lives as long as
> the connection to main center is down.

This would mean your system goes from Master-Slave to Multi-Master if
your main DB goes down. Roll your own replication time.

pgsql-general by date:

Previous
From: William Yu
Date:
Subject: Re: Is it databases in general, SQL or Postgresql?
Next
From: "Magnus Hagander"
Date:
Subject: Re: Customizing the Windows installer