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* *willjdunn.com <http://willjdunn.com>* On Tue, Jul 21, 2015 at 3:31 PM, Joshua D. Drake <j...@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. >
