[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
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
More information about the pgpool-general
mailing list