[pgpool-general: 6475] pgpool-II does nothing when slave node goes down

Dmitry Medvedev dm.dm.medvedev at gmail.com
Tue Mar 26 23:58:44 JST 2019


Hello to everyone.

A couple of days I've spent trying to understand how pgpool-II works.
Tell me, please, principle of operation when slave node goes down.
I've read tons of manuals and when master node in my test cluster goes down
(or master's network interface goes down) - pgpool does failover actions.
Everything is OK and works as expected.
But when slave node goes down - pgpool does nothing at all and I receive
such answer

test=# show pool_nodes;
 node_id |  hostname   | port | status | lb_weight |  role  | select_cnt |
load_balance_node | replication_delay | last_status_change
---------+-------------+------+--------+-----------+--------+------------+-------------------+-------------------+---------------------
 0       | 172.28.30.6 | 5434 | up     | 0.500000  | master | 3          |
true              | 0                 | 2019-03-26 17:04:12
 1       | 172.28.30.7 | 5434 | up     | 0.500000  | slave  | 0          |
false             | 0                 | 2019-03-26 17:04:12
(2 rows)


At the same time slave node is completely down. Not "up"! select * from
pg_stat_replication showing (0 rows)

Why does pgpool-II does nothing when slave node goes down and how I can
change it?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190326/6a3d8e89/attachment.html>


More information about the pgpool-general mailing list