Re: [GENERAL] Postgres HA - Mailing list pgsql-general

From John R Pierce
Subject Re: [GENERAL] Postgres HA
Date
Msg-id 1d985480-08a3-7db8-b2cd-2c74cf82b6c8@hogranch.com
Whole thread Raw
In response to [GENERAL] Postgres HA  (Dylan Luong <Dylan.Luong@unisa.edu.au>)
List pgsql-general
On 2/22/2017 2:58 PM, Dylan Luong wrote:
> For PostgreSQL High Availability, we currently have setup a
> Master/Slave across two datacenters using PostgreSQL (WAL) streaming
> replication.

have you considered the ramifications of network problems between these
two datacenters?    with a master/slave cluster, you need to avoid the
'split  brain' scenario where both servers think they are master because
they can't reach the other.




--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: JD
Date:
Subject: Re: [GENERAL] Postgres HA
Next
From: Jehan-Guillaume de Rorthais
Date:
Subject: Re: [GENERAL] Postgres HA