[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.pgpool.net/pipermail/pgpool-general/attachments/20190326/6a3d8e89/attachment.htm>
More information about the pgpool-general
mailing list