[pgpool-general: 4449] Re: Status in pool_nodes
Yugo Nagata
nagata at sraoss.co.jp
Mon Feb 15 15:12:37 JST 2016
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>
More information about the pgpool-general
mailing list