[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