Re: Setting up HA postgresql

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: William Dunn <dunnwjr(at)gmail(dot)com>, Aviel Buskila <aviel33(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Setting up HA postgresql
Date: 2015-07-21 19:31:48
Message-ID: 55AE9E24.4080004@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 07/21/2015 11:04 AM, William Dunn wrote:
> If you dig deeper into pgpool-II you will find that it does not have
> failover logic. Its intention is to pool connections and distribute
> query load among replicas, but it cannot differentiate node failure from
> network partition and cannot promote a standby to master in the case of
> failure.

If you dig deeper, I think you would find your statement is no longer
accurate:

http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html

JD

--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Kregloh 2015-07-21 19:36:28 Re: Promoting 1 of 2 slaves
Previous Message William Dunn 2015-07-21 18:37:42 Re: Promoting 1 of 2 slaves