[pgpool-general: 7648] Re: Why isn't watchdog required on Kubernetes?

Bo Peng pengbo at sraoss.co.jp
Mon Jul 26 11:53:01 JST 2021

> Hello!
> > Pgpool-II's health check, automatic failover, Watchdog and online
> > recovery features aren't required onKubernetes. You need to only
> > enable load balancing and connection pooling.
> Says this page:
> https://www.pgpool.net/docs/latest/en/html/example-kubernetes.html
> <https://www.pgpool.net/docs/latest/en/html/example-kubernetes.html>
> How come? Does Kubernetes somehow magically eliminate the problem of
> having a single point of failure in form of PGPool?

Pgpool is deployed as "kind: Deployment".
If pgpool pod goes down, Kubernetes will restart another one.

To completely eliminate downtime, you may increase the number of "replicas".

kind: Deployment
  name: pgpool
  replicas: 3

If you are setting more than 1 replicas, you need to configure 
"max_pool", "num_init_children", "max_connections" and
"superuser_reserved_connections" to satisfy:

   number of Pgpool-II replicas × max_pool × num_init_children <= (max_connections - superuser_reserved_connections) 

Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan

More information about the pgpool-general mailing list