[pgpool-general: 4446] Status in pool_nodes
Dmitry Voronin
carriingfate92 at yandex.ru
Fri Feb 12 17:34:41 JST 2016
Hello,
I'm using pgpool2 3.4.3 on Ubuntu. I have to clusters (master-slave in streaming replication) and I set pgpool2 in stream mode.
I successfully connect to pgpool (which are working on 6000 port) and execute SHOW pool_nodes;
So, I have:
node_id | hostname | port | status | lb_weight | role
---------+-----------+------+--------+-----------+---------
0 | 127.0.0.1 | 5432 | 2 | 0.500000 | primary
1 | 127.0.0.1 | 5433 | 0 | 0.500000 | standby
(2 rows)
The question is: why status of standby cluster is 0? I found in pgpool documentation, that 0 status is only used during the initialization. PCP will never display it. Thank you.
--
Best regards, Dmitry Voronin
More information about the pgpool-general
mailing list