Re: [GENERAL] Postgres HA

2017-02-24 Thread
Julyanto Sutandang wrote: > Talking about High Availability, we should understand the basic concept of > HA, it is avoiding SPOF (Single Point of Failure). When we use a Loadbalancer > (LTM) and that load balancer is single, then you may get HA only for the > PostgreSQL but

Re: [GENERAL] Postgres HA

2017-02-23 Thread Julyanto Sutandang
Dear Dylan, Talking about High Availability, we should understand the basic concept of HA, it is avoiding SPOF (Single Point of Failure). When we use a Loadbalancer (LTM) and that load balancer is single, then you may get HA only for the PostgreSQL but there are another single point of failure,

Re: [GENERAL] Postgres HA

2017-02-23 Thread dinesh kumar
Hi Dylan, On Thu, Feb 23, 2017 at 4:28 AM, Dylan Luong wrote: > Hi > > > > I am a DBA at the University of South Australia. For PostgreSQL High > Availability, we currently have setup a Master/Slave across two datacenters > using PostgreSQL (WAL) streaming replication.

Re: [GENERAL] Postgres HA

2017-02-23 Thread Jehan-Guillaume de Rorthais
On Wed, 22 Feb 2017 22:58:10 + Dylan Luong wrote: > Hi > > I am a DBA at the University of South Australia. For PostgreSQL High > Availability, we currently have setup a Master/Slave across two datacenters > using PostgreSQL (WAL) streaming replication. We use an

Re: [GENERAL] Postgres HA

2017-02-22 Thread John R Pierce
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

Re: [GENERAL] Postgres HA

2017-02-22 Thread JD
Here is the option for HA i.e. EDB failover manager. https://www.enterprisedb.com/docs/en/2.1/edbfm/EDB_Failover_Manager_Guide.1.02.html On Thu, Feb 23, 2017 at 10:08 AM, Venkata B Nagothi wrote: > > On Thu, Feb 23, 2017 at 9:58 AM, Dylan Luong >

Re: [GENERAL] Postgres HA

2017-02-22 Thread Venkata B Nagothi
On Thu, Feb 23, 2017 at 9:58 AM, Dylan Luong wrote: > Hi > > > > I am a DBA at the University of South Australia. For PostgreSQL High > Availability, we currently have setup a Master/Slave across two datacenters > using PostgreSQL (WAL) streaming replication. We use an

Re: [GENERAL] Postgres HA

2017-02-22 Thread Andrew Sullivan
Hi, On Wed, Feb 22, 2017 at 10:58:10PM +, Dylan Luong wrote: > > I am looking at options to improve our high availability. I suspect the central question you have to answer is, "What do you mean by 'improve'?" Do you want to increase the ability to retrieve data? Decrease the potential

[GENERAL] Postgres HA

2017-02-22 Thread Dylan Luong
Hi I am a DBA at the University of South Australia. For PostgreSQL High Availability, we currently have setup a Master/Slave across two datacenters using PostgreSQL (WAL) streaming replication. We use an LTM (load balancer) server that sits between the application servers and the PostgreSQL