[pgpool-general: 3170] Re: Cannot run 'show pool_nodes'

[jayknowsunix at gmail.com]

I am connecting to the VIP which was brought up by pgpool. I have even restarted pgpool on each machine in the cluster and verified that the VIP was being managed by pgpool (the VIP disappeared while pgpool was off and came back when it was restarted.) i have also verified that connection pooling is on for each system. Is there something else I can check?

Sent from my iPad

> On Sep 17, 2014, at 10:51 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> 
> You need to connect pgpool-II, not connect directry to PostgreSQL
> because "show pool_nodes" is a pgpool-II specific SQL command.
> Here is an example session.
> 
> test=# show pool_nodes;
> node_id | hostname | port  | status | lb_weight |  role   
> ---------+----------+-------+--------+-----------+---------
> 0       | /tmp     | 11000 | 2      | 0.500000  | primary
> 1       | /tmp     | 11001 | 2      | 0.500000  | standby
> (2 rows)
> 
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
> 
>> In response to my question yesterday, Ishii-san suggested running 'show pool_nodes;' I tried running this command this morning in a psql session, but was unsuccessful. The error was a simple not found one. Apparently, I've missed a step during setup, and I've been going back through the online tutorial, but I'm not seeing what I need. Also, looking online at what this command does, it doesn't appear to give more information than pcp_node_info does. That utility does work for me, btw. Am I mistaken? I'm just trying to determine which pgpool instance is the master in a master-slave configuration after a failover attempt.
>> --
>> Jay
>> 
>> Sent from my iPad
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general