[pgpool-general: 2727] Re: pgpool-ha 2.2 released

[TAKATSUKA Haruka]

Ishii-san,

> Caution: multiple pgpool instances will not work correctly without
> watchdog. For example, failover script may be executed by multiple
> pgpool instances at a same time when one of PostgreSQL nodes goes
> down. Also it's possible that online recovery script can be executed
> by multiple pgpool instances.

This means
multiple pgpool instances *for same backend Postgres instances*
not work without watchdog, doesn't it?

> >  - manage multi pgpool instances (with single heartbeat pair)

I say about multiple pgpool instances that independent from each other.

with best regards, 
 ______________________________________________________________________
 TAKATSUKA Haruka  harukat at sraoss.co.jp  SRA OSS, Inc .


On Mon, 07 Apr 2014 21:33:42 +0900 (JST)
Tatsuo Ishii <ishii at postgresql.org> wrote:

> > Hi.
> > 
> > When you want to do something complicated , it's used.
> > e.g.
> >  - use two or more VIP in different N/W segments
> >  - manage other deamons on same HA cluster with pgpool
> >  - manage multi pgpool instances (with single heartbeat pair)
> 
> Caution: multiple pgpool instances will not work correctly without
> watchdog. For example, failover script may be executed by multiple
> pgpool instances at a same time when one of PostgreSQL nodes goes
> down. Also it's possible that online recovery script can be executed
> by multiple pgpool instances.



> 
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
> 
> > On Sun, 06 Apr 2014 17:07:47 -0700
> > Alexandru Cardaniuc <cardaniuc at gmail.com> wrote:
> > 
> >> Any reason to use pgpool-HA instead of watchdog in pgpool 3.3.3?
> >> 
> >> TAKATSUKA Haruka <harukat at sraoss.co.jp> writes:
> >> 
> >> > pgpool-ha 2.2 released -------------------------
> >> >
> >> > Version 2.2 of pgpool-ha, the OCF resource agent script for pgpool-II
> >> > on HA cluster management softwares such as Pacemaker, has been
> >> > released and is publicly available for download.
> >> >
> >> >   Download: http://pgpool.net/mediawiki/index.php/Downloads#pgpool-HA
> >> >
> >> > This version fixes bugs following:
> >> >
> >> >   * fix metadata for pcs command's xml parser. This causes "Unable to
> >> > parse xml" error at "pcs resource describe" command of Pacemaker 1.1.x
> >> > (http://www.pgpool.net/mantisbt/view.php?id=91)
> >> >
> >> >   * add wait loop to start action function. This causes an
> >> > inappropriate failure of monitoring action. (reported by
> >> > [pgpool-general: 2123])
> >> >
> >> > _______________________________________________ pgpool-general mailing
> >> > list pgpool-general at pgpool.net
> >> > http://www.pgpool.net/mailman/listinfo/pgpool-general
> >> >
> >> >
> >> 
> >> -- 
> >> "The only thing necessary for evil to flourish is for good men to do
> >> nothing."  
> >> - Edmund Burke
> >