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

From Joshua D. Drake
Subject Re: Setting up HA postgresql
Date
Msg-id 55AEAB34.6040807@commandprompt.com
Whole thread Raw
In response to Re: Setting up HA postgresql  (William Dunn <dunnwjr@gmail.com>)
Responses Re: Setting up HA postgresql  (William Dunn <dunnwjr@gmail.com>)
List pgsql-general
On 07/21/2015 01:21 PM, William Dunn wrote:
> 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.

 From what I see, it has the ability to execute a command/script based
on a failed condition which could include but not be limited to a
command to fail over a standby.

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: William Dunn
Date:
Subject: Re: Setting up HA postgresql
Next
From: William Dunn
Date:
Subject: Re: Setting up HA postgresql