[pgpool-general: 4449] Re: Status in pool_nodes

[Yugo Nagata]

Hi,

On Fri, 12 Feb 2016 11:34:41 +0300
Dmitry Voronin <carriingfate92 at yandex.ru> wrote:

> 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.

I can't reproduce this. Can is this reproduced repeatedly?
If so, could you provide us pgpool.conf and also the results of
"show pool_status" and pcp_node_info?

> 
> -- 
> Best regards, Dmitry Voronin
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


-- 
Yugo Nagata <nagata at sraoss.co.jp>