[Pgpool-general] pg_terminate_backend triggers failover on pgpool when used as standalone pool

[Glyn Astill]

> From: Tatsuo Ishii <ishii at sraoss.co.jp>
> Subject: Re: [Pgpool-general] pg_terminate_backend triggers failover on pgpool when used as standalone pool
> To: glynastill at yahoo.co.uk
> Cc: pgpool-general at pgfoundry.org
> Date: Wednesday, 12 May, 2010, 14:08
> > My conf file is as follows (I've
> removed comments etc for clarity)
> [snip]
> 
> It seems the problem occurs when there's only one DB node.
> 
> 1) it tries to failover to non existing node
> 
> 2) it makes the node into down status which might not what
> you want.
> 
> #1 is purely a bug. I fix this and for #2 I'm leaning to
> change
> existing behavior.
> 
> - In row mode and if there's only one DB node, if a problem
> occurs
>   with the DB node, it will be brought to down status.
> However if the
>   DB node goes into good condition again, you can use
> the DB node
>   without restarting pgpool.
> 
> - In other mode the behavior is not changed.
> 
> Including is the patch for this. Please try.
> 

Hi Tatsuo,

That works as expected. Thanks!

Glyn