Re: Setting up HA postgresql

Поиск
Список
Период
Сортировка
От William Dunn
Тема Re: Setting up HA postgresql
Дата
Msg-id CAEva=Vnyi7cOBxWwkKe26iJ_p_NDAY-geCZevHV-brX6UZ73qQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Setting up HA postgresql  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Setting up HA postgresql  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
That's pretty cool! But the intended use of watchdog is so you can have multiple pgpool-II instances and failover among them (http://www.pgpool.net/docs/latest/pgpool-en.html#watchdog) rather than failure of Postgres. In the configuration described in that wiki what happens when the DBMS goes down but pgpool-II is fine? The watchdog appears to be monitoring the pgpool-II process, not the postgres/postmaster process.

Will J. Dunn

On Tue, Jul 21, 2015 at 3:31 PM, Joshua D. Drake <jd@commandprompt.com> wrote:

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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Cannot reach pg server using -h localhost
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Setting up HA postgresql