[pgpool-general: 2974] Re: Show commands not working

[Tatsuo Ishii]

Hi,

You need to connect to the port which is specified by "port" directive
in pgpool.conf.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Ishii-san,
> 
> Yes, I'm getting 'unrecognized configuration parameter "pool_status"
> What parameters should I be using with psql to see the results of
> these commands? I'm guessing that I do not want to connect to psql
> with port 5432 like normal.
> 
> Arrigato,
> Jay
> 
> On 6/24/2014 6:34 PM, Tatsuo Ishii wrote:
>>> On the webpage: http://www.pgpool.net/docs/latest/pgpool-en.html about
>>> 1/2 down into the page, there is a section for SHOW commands like
>>> pool_status, etc., and on my system none of these are working. I just
>>> get an error message when I enter them into psql.
>>>
>>> I've probably missed installing some things as I'm not using pgpool
>>> for all tasks, but I cannot tell what I've missed that would add this
>>> functionality into the system.
>>>
>>> Any ideas?
>> What kind of error message do you get?
>> If it's something like:
>> ERROR:  unrecognized configuration parameter "aaa"
>>
>> then it is likely you do not connect to pgpool, but connect to
>> PostgreSQL. Please verify port number and other connection parameters
>> given to psql is correct.
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>
>