[pgpool-general: 6287] Re: alternative to 'virtual IP' ?

[Tatsuo Ishii]

> Dear All.
> 
> IMHO using 'virtual IP' as watchdog action is good as long as all PGPOOL
> nodes is in the same IP Network.
> 
> Is there any way that we can triger external script whenever a PGPOOL node
> promoted to as 'master' ?

Yes.
http://www.pgpool.net/docs/latest/en/html/runtime-watchdog-config.html#GUC-WD-ESCALATION-COMMAND

Also there's an example to show how to use this in AWS.
http://www.pgpool.net/docs/latest/en/html/example-aws.html

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp