Re: Setting up HA postgresql - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Setting up HA postgresql
Date
Msg-id 55AF0690.3020504@commandprompt.com
Whole thread Raw
In response to Re: Setting up HA postgresql  (Tatsuo Ishii <ishii@postgresql.org>)
List pgsql-general
On 07/21/2015 07:07 PM, Tatsuo Ishii wrote:
>
>> But it appears that the fail condition for "watchdog" is the failure of a
>> pgpool-II instance. In the configuration described in the wiki you would
>> put a pgpool-II instance on each Postgres node, and if one of the pgpool-II
>> instances fails it executes a script (which can create the trigger file to
>> promote the standby to master). However, if the fail condition for watchdog
>> is a failure of the pgpool-II instance what happens if the DBMS has
>> availability issues but the pgpool-II process on that server is ok? The
>> fail condition would never be triggered, right?
>
> No. The condition (PostgreSQL failure) will be detected by one of
> pgpool-II (not watchdog process) and the pgpool-II will disconnect the
> failed PostgreSQL, then execute failover script (if defined) which
> will usually promote standby PostgreSQL (if failed PostgreSQL was
> primary) or just ignore the broken PostgreSQL if it was standby.

Thank you Tatsuo, I was having trouble explaining.

Sincerely,

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 by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Setting up HA postgresql
Next
From: Chris Mair
Date:
Subject: Re: Cannot reach pg server using -h localhost