pgpool2.git / summary / log / commit / refs
commit c751dcd0a2cf26c1554459d5cea866facced01ed
Author: Nozomi Anzai <anzai@sraoss.co.jp>
Date: Wed May 30 02:36:00 2012 +0000
Add desctiption of pcp_pool_status command.
doc/pgpool-en.html | 43 ++++++++++++++++++++++++++++++++++++-------
doc/pgpool-ja.html | 32 +++++++++++++++++++++++++++++++-
2 files changed, 67 insertions(+), 8 deletions(-)
diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html
index dd3fabb49..214a4818b 100644
--- a/doc/pgpool-en.html
+++ b/doc/pgpool-en.html
@@ -2906,13 +2906,13 @@ but the other ones have appeared in release 3.0.</p>
their name, value, and description. Here is an excerpt of the result:
<pre>
benchs2=# show pool_status;
- item | value | description
--------------------------------+---------------------------------+------------------------------------------------------------------
- listen_addresses | 127.0.0.1 | host name(s) or IP address(es) to listen to
- port | 9999 | pgpool accepting port number
- socket_dir | /tmp | pgpool socket directory
- num_init_children | 5 | # of children initially pre-forked
- child_life_time | 300 | if idle for this seconds, child exits
+ item | value | description
+--------------------------------------+--------------------------------+------------------------------------------------------------------
+ listen_addresses | localhost | host name(s) or IP address(es) to listen to
+ port | 9999 | pgpool accepting port number
+ socket_dir | /tmp | pgpool socket directory
+ pcp_port | 9898 | PCP port # to bind
+ pcp_socket_dir | /tmp | PCP socket directory
</pre>
</p>
@@ -4178,6 +4178,8 @@ invalidate old query cache automatically when the data is updated.</p>
<td>retrieves the process list</td></tr>
<tr><th><a href="#pcp_proc_info">pcp_proc_info</a></th>
<td>retrieves the process information</td></tr>
+<tr><th><a href="#pcp_pool_status ">pcp_pool_status</a></th>
+ <td>retrieves parameters in pgpool.conf</td></tr>
<tr><th><a href="#pcp_systemdb_info">pcp_systemdb_info</a></th>
<td>retrieves the System DB information</td></tr>
<tr><th><a href="#pcp_detach_node">pcp_detach_node</a></th>
@@ -4352,6 +4354,33 @@ Connected : 1
<p>Specifying an invalid node ID will result in an error with exit
status 12, and BackendError will be displayed.</p>
+<h3 id="pcp_pool_status">pcp_pool_status</h3>
+<pre>
+Format:
+pcp_pool_status _timeout_ _host_ _port_ _userid_ _passwd_
+</pre>
+<p>
+Displays parameters in pgpool.conf. The output example is as follows:
+</p>
+<pre>
+$ pcp_pool_status 10 localhost 9898 postgres hogehoge
+name : listen_addresses
+value: localhost
+desc : host name(s) or IP address(es) to listen to
+
+name : port
+value: 9999
+desc : pgpool accepting port number
+
+name : socket_dir
+value: /tmp
+desc : pgpool socket directory
+
+name : pcp_port
+value: 9898
+desc : PCP port # to bind
+</pre>
+
<h3 id="pcp_systemdb_info">pcp_systemdb_info</h3>
<p>
<pre>
diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html
index 7376d5f41..ab73515af 100644
--- a/doc/pgpool-ja.html
+++ b/doc/pgpool-ja.html
@@ -4314,6 +4314,8 @@ pgpool-II$B$rA`:n$9$k(BUNIX$B%3%^%s%I$H$7$F!"0J2<$N$b$N$,$"$j$^$9!#(B
<td>$B%W%m%;%90lMw$r<hF@$9$k(B</td></tr>
<tr><th><a href="#pcp_proc_info">pcp_proc_info</a></th>
<td>$B%W%m%;%9>pJs$r<hF@$9$k(B</td></tr>
+<tr><th><a href="#pcp_pool_status">pcp_pool_status</a></th>
+ <td>pgpool.conf $B$N%Q%i%a!<%?@_DjCM$r<hF@$9$k(B</td></tr>
<tr><th><a href="#pcp_systemdb_info">pcp_systemdb_info</a></th>
<td>$B%7%9%F%`(BDB$B>pJs$r<hF@$9$k(B</td></tr>
<tr><th><a href="#pcp_detach_node">pcp_detach_node</a></th>
@@ -4452,13 +4454,41 @@ postgres_db postgres 1150769932 1150767351 3 0 1 14068 1
$BDj5A$5$l$F$$$J$$%W%m%;%9(BID$B$r;XDj$9$k$H(BBackendError$B$HI=<($5$l!"(B<a href="#exit_status">$B=*N;%3!<%I(B12</a>$B$G=*N;$7$^$9!#(B
</pre>
+<h3 id="pcp_pool_status">pcp_pool_status</h3>
+<pre>
+$B=q<0(B:
+pcp_pool_status _timeout_ _host_ _port_ _userid_ _passwd_
+</pre>
+<p>pgpool.conf $B$N%Q%i%a!<%?@_DjCM$r<hF@$7$^$9!#=PNO7k2L$O0J2<$NDL$j$G$9!#(B</p>
+<pre>
+$ pcp_pool_status 10 localhost 9898 postgres hogehoge
+name : listen_addresses
+value: localhost
+desc : host name(s) or IP address(es) to listen to
+
+name : port
+value: 9999
+desc : pgpool accepting port number
+
+name : socket_dir
+value: /tmp
+desc : pgpool socket directory
+
+name : pcp_port
+value: 9898
+desc : PCP port # to bind
+</pre>
+
+
<h3 id="pcp_systemdb_info">pcp_systemdb_info</h3>
<pre>
$B=q<0!'(B
pcp_systemdb_info _timeout_ _host_ _port_ _userid_ _passwd_
+</pre>
-pgpool-II$B$N%7%9%F%`(BDB$B>pJs$rI=<($7$^$9!#=PNO7k2L$O0J2<$NDL$j$G$9!#(B
+<p>pgpool-II$B$N%7%9%F%`(BDB$B>pJs$rI=<($7$^$9!#=PNO7k2L$O0J2<$NDL$j$G$9!#(B</p>
+<pre>
$ pcp_systemdb_info 10 localhost 9898 postgres hogehoge
localhost 5432 yamaguti '' pgpool_catalog pgpool 3
yamaguti public accounts aid 4 aid bid abalance filler integer integer integer character(84) dist_def_accounts
[parent: 4bd9eeac315f]