[pgpool-general: 6651] Cluster with 3 nodes

[Гиа Хурцилава]

Гиа Хурцилава <khurtsilava.g at gmail.com>
чт, 25 июл., 13:56 (21 час назад)
кому: pgpool-general

Hi there.

I’ve got 3 machines with pgpool-4.0.5 and postgresql-11. I have done
configuration for pgpool from the official documentations (
http://www.pgpool.net/docs/latest/en/html/example-cluster.html) and
everything works fine, except 1 thing. When I’m shutting down master node,
one of the slaves is correctly promoted, and another one is going down with
master. Just like that:

node_id | hostname | port | status | lb_weight |  role   | select_cnt |
load_balance_node | replication_delay | last_status_change

---------+----------+------+--------+-----------+---------+------------+-------------------+-------------------+---------------------

 0       | master   | 5432 | down   | 0.333333  | standby | 0          |
false             | 0                 | 2019-07-25 13:49:22

 1       | slave      | 5432 | up         | 0.333333  | primary | 0
  | true              | 0                | 2019-07-25 13:49:22

 2       | reserve  | 5432 | down   | 0.333333  | standby | 0          |
false             | 0                 | 2019-07-25 13:49:22



What reason can be of this behavior? How can I fix it?

If you’ll need logs or config files-let me know. Thanks.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190726/bebf0128/attachment.html>