[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