[pgpool-general: 7255] Pgpool-HA without watchdog, kubernetes scenario.

Rafael Rios Saavedra rafael.rios.saavedra at gmail.com
Wed Sep 2 00:24:15 JST 2020

  First of all I am not very sure if this is the right list to post this
question, if it is not, please point me to the appropriate place.

  I would like to deploy pgpool in HA in kubernetes, but as kubernetes
handle all the liveness test of the nodes, load balancing and "virtual" IPs
handling, I would like to know what I should configure in pgpool.
  Let's say I would like to run 2 instances of pgpool, if I have a Load
balancer that send requests to the nodes, Would it be safe to do just that,
or does a pgpool instance need to know the others to sync some information
  I have seen this
<https://www.pgpool.net/docs/latest/en/html/example-aws.html> and this
<https://www.pgpool.net/docs/latest/en/html/example-aws.html> pages, but it
is not clear to me if the `other_xxxx` parameters are used just for
watchdogging or there is more involved that I am missing.

Example configuration from the AWS link.

use_watchdog = on
delegate_IP = ''
wd_hostname = 'instance-1-private-ip'
other_pgpool_hostname0 = 'instance-2-private-ip'
other_pgpool_port0 = 9999
other_wd_port0 = 9000
wd_escalation_command = '$path_to_script/aws-escalation.sh'
wd_de_escalation_command = '$path_to_script/aws-de-escalation.sh

Thanks forehand.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200901/97d640be/attachment.html>

More information about the pgpool-general mailing list