<html><head><meta http-equiv="content-type" content="text/html; charset=UTF-8"><style>body { line-height: 1.5; }blockquote { margin-top: 0px; margin-bottom: 0px; margin-left: 0.5em; }body { font-size: 10.5pt; font-family: 'Microsoft YaHei UI'; color: rgb(0, 0, 0); line-height: 1.5; }body { font-size: 10.5pt; font-family: 'Microsoft YaHei UI'; color: rgb(0, 0, 0); line-height: 1.5; }</style></head><body>
<div><span></span>Hi ,</div><div> when you execute "show pool_status" command after connect postgresql <span style="font-size: 10.5pt; line-height: 1.5; background-color: window;">straightly but not by the pool of pgpool-II, you will recieve the error,</span><span style="font-size: 10.5pt; line-height: 1.5; background-color: window;">ERROR: unrecognized configuration parameter "pool_status"</span></div><div><span style="font-size: 10.5pt; line-height: 1.5; background-color: window;">f.e</span></div><div><span microsoft="" yahei="" ui';="" font-size:="" 14px;="" color:="" rgb(0,="" 0,="" 0);="" background-color:="" rgb(255,="" 255,="" 255);="" font-weight:="" normal;="" font-style:="" normal;text-decoration:="" none;'="">[postgres@pipeline-srv1 ~]$ psql<br>psql (11.1)<br>Type "help" for help.<br><br>postgres=# show pool_status;<br>ERROR: unrecognized configuration parameter "pool_status"</span></div><div><span microsoft="" yahei="" ui';="" font-size:="" 14px;="" color:="" rgb(0,="" 0,="" 0);="" background-color:="" rgb(255,="" 255,="" 255);="" font-weight:="" normal;="" font-style:="" normal;text-decoration:="" none;'=""><br></span></div><div>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</div><div>f.e</div><div><span microsoft="" yahei="" ui';="" font-size:="" 14px;="" color:="" rgb(0,="" 0,="" 0);="" background-color:="" rgba(0,="" font-weight:="" normal;="" font-style:="" normal;text-decoration:="" none;'="">[postgres@pipeline-srv1 ~]$ psql -p 9999<br>psql (11.1)<br>Type "help" for help.<br><br>postgres=# show pool_status;<br> item | value <br> | description <br>--------------------------------------+-----------------------------------------------------<br>-------+---------------------------------------------------------------------------------<br> listen_addresses | * <br> | host name(s) or IP address(es) to listen on</span></div><div><br></div><div><br></div><hr style="width: 210px; height: 1px;" color="#b5c4df" size="1" align="left">
<div><span><div style="MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt"><div>dw_qiuchunxiao@sina.com</div></div></span></div>
<blockquote style="margin-Top: 0px; margin-Bottom: 0px; margin-Left: 0.5em"><div> </div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><div style="PADDING-RIGHT: 8px; PADDING-LEFT: 8px; FONT-SIZE: 12px;FONT-FAMILY:tahoma;COLOR:#000000; BACKGROUND: #efefef; PADDING-BOTTOM: 8px; PADDING-TOP: 8px"><div><b>From:</b> <a href="mailto:pgpool-general-request@pgpool.net">pgpool-general-request</a></div><div><b>Date:</b> 2018-12-07 11:00</div><div><b>To:</b> <a href="mailto:pgpool-general@pgpool.net">pgpool-general</a></div><div><b>Subject:</b> pgpool-general Digest, Vol 86, Issue 5</div></div></div><div><div> </div>
<div>Send pgpool-general mailing list submissions to</div>
<div> pgpool-general@pgpool.net</div>
<div> </div>
<div>To subscribe or unsubscribe via the World Wide Web, visit</div>
<div> http://www.sraoss.jp/mailman/listinfo/pgpool-general</div>
<div>or, via email, send a message with subject or body 'help' to</div>
<div> pgpool-general-request@pgpool.net</div>
<div> </div>
<div>You can reach the person managing the list at</div>
<div> pgpool-general-owner@pgpool.net</div>
<div> </div>
<div>When replying, please edit your Subject line so it is more specific</div>
<div>than "Re: Contents of pgpool-general digest..."</div>
<div> </div>
<div> </div>
<div>Today's Topics:</div>
<div> </div>
<div> 1. [pgpool-general: 6327] Show pool_status command ! (Nitish Kumar)</div>
<div> </div>
<div> </div>
<div>----------------------------------------------------------------------</div>
<div> </div>
<div>Message: 1</div>
<div>Date: Thu, 06 Dec 2018 18:26:07 +0530</div>
<div>From: Nitish Kumar <itcell.mpwz@mp.gov.in></div>
<div>To: PgPool General <pgpool-general@pgpool.net></div>
<div>Subject: [pgpool-general: 6327] Show pool_status command !</div>
<div>Message-ID: <fa90b5d82d75.5c0969bf@nic.in></div>
<div>Content-Type: text/plain; charset="us-ascii"</div>
<div> </div>
<div>Hi All,</div>
<div> </div>
<div>Receiving following logs in my PostgreSQL 10 database nodes which are under PgPool II.</div>
<div> </div>
<div> </div>
<div>2018-12-06 15:38:14.437 IST [3968] pgpool_hc@template1/<pg-pool-ip-masked>(59638) ERROR: unrecognized configuration parameter "pool_status"</div>
<div>2018-12-06 15:38:14.437 IST [3968] pgpool_hc@template1/<pg-pool-ip-masked>(59638) STATEMENT: SHOW pool_status</div>
<div> </div>
<div> </div>
<div>I doubt that this SHOW pool_status command is not meant for running on PostgreSQL node. </div>
<div> </div>
<div>Is this normal and correct or I have a misconfiguration somewhere in my PgPool II settings.</div>
<div> </div>
<div>Regards,</div>
<div>Nitish Kumar</div>
<div>-------------- next part --------------</div>
<div>An HTML attachment was scrubbed...</div>
<div>URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20181206/1ab83006/attachment-0001.html></div>
<div> </div>
<div>------------------------------</div>
<div> </div>
<div>_______________________________________________</div>
<div>pgpool-general mailing list</div>
<div>pgpool-general@pgpool.net</div>
<div>http://www.pgpool.net/mailman/listinfo/pgpool-general</div>
<div> </div>
<div> </div>
<div>End of pgpool-general Digest, Vol 86, Issue 5</div>
<div>*********************************************</div>
<div> </div>
<div> </div>
</div></blockquote>
</body></html>