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

Tatsuo Ishii ishii at postgresql.org
Wed Sep 17 23:51:26 JST 2014

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

> 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

More information about the pgpool-general mailing list