[pgpool-general: 6328] Re: pgpool-general Digest, Vol 86, Issue 5

[mandy]

Hi ,
 when you execute "show pool_status" command after connect postgresql straightly but not by the pool of pgpool-II, you will recieve the error,ERROR: unrecognized configuration parameter "pool_status"
f.e
[postgres at pipeline-srv1 ~]$ psql
psql (11.1)
Type "help" for help.

postgres=# show pool_status;
ERROR:  unrecognized configuration parameter "pool_status"

You should execute "show pool_status" command after you  executed "psql -p 9999（the default port of pgpool-II）which connect postgresql db by pgpool-II
f.e
[postgres at pipeline-srv1 ~]$ psql -p 9999
psql (11.1)
Type "help" for help.

postgres=# show pool_status;
                 item                 |                           value                     
       |                                   description                                   
--------------------------------------+-----------------------------------------------------
-------+---------------------------------------------------------------------------------
 listen_addresses                     | *                                                   
       | host name(s) or IP address(es) to listen on




dw_qiuchunxiao at sina.com
 
From: pgpool-general-request
Date: 2018-12-07 11:00
To: pgpool-general
Subject: pgpool-general Digest, Vol 86, Issue 5
 
Send pgpool-general mailing list submissions to
pgpool-general at pgpool.net
 
To subscribe or unsubscribe via the World Wide Web, visit
http://www.sraoss.jp/mailman/listinfo/pgpool-general
or, via email, send a message with subject or body 'help' to
pgpool-general-request at pgpool.net
 
You can reach the person managing the list at
pgpool-general-owner at pgpool.net
 
When replying, please edit your Subject line so it is more specific
than "Re: Contents of pgpool-general digest..."
 
 
Today's Topics:
 
   1. [pgpool-general: 6327] Show pool_status command ! (Nitish Kumar)
 
 
----------------------------------------------------------------------
 
Message: 1
Date: Thu, 06 Dec 2018 18:26:07 +0530
From: Nitish Kumar <itcell.mpwz at mp.gov.in>
To: PgPool General <pgpool-general at pgpool.net>
Subject: [pgpool-general: 6327] Show pool_status command !
Message-ID: <fa90b5d82d75.5c0969bf at nic.in>
Content-Type: text/plain; charset="us-ascii"
 
Hi All,
 
Receiving following logs in my PostgreSQL 10 database nodes which are under PgPool II.
 
 
2018-12-06 15:38:14.437 IST [3968] pgpool_hc at template1/<pg-pool-ip-masked>(59638) ERROR: unrecognized configuration parameter "pool_status"
2018-12-06 15:38:14.437 IST [3968] pgpool_hc at template1/<pg-pool-ip-masked>(59638) STATEMENT: SHOW pool_status
 
 
I doubt that this SHOW pool_status command is not meant for running on PostgreSQL node. 
 
Is this normal and correct or I have a misconfiguration somewhere in my PgPool II settings.
 
Regards,
Nitish Kumar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20181206/1ab83006/attachment-0001.html>
 
------------------------------
 
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general
 
 
End of pgpool-general Digest, Vol 86, Issue 5
*********************************************
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20181207/ecce3a12/attachment.html>