pgpool2.git / summary / log / commit / refs
commit 8bbf38da347819662fcc96010494c1cbe8908d88
Author: Tatsuo Ishii <ishii at sraoss.co.jp>
Date: Wed Aug 11 03:04:06 2010 +0000
Sync with English doc.
doc/pgpool-ja.html | 132 ++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 file changed, 130 insertions(+), 2 deletions(-)
diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html
index b05d38fdf..91cc35fae 100644
--- a/doc/pgpool-ja.html
+++ b/doc/pgpool-ja.html
@@ -8,7 +8,7 @@
<body>
<!-- hhmts start -->
-Last modified: Tue Aug 10 11:34:57 JST 2010
+Last modified: Wed Aug 11 12:01:54 JST 2010
<!-- hhmts end -->
<body bgcolor="#ffffff">
@@ -35,6 +35,7 @@ Last modified: Tue Aug 10 11:34:57 JST 2010
<li><a href="#stream">Streaming Replication$B$X$NBP1~(B</a></li>
<li><a href="#start">pgpool-II$B$N5/F0$HDd;_(B</a></li>
<li><a href="#reload">pgpool-II$B$N@_Dj%U%!%$%k$N:FFI$_9~$_(B</a></li>
+ <li><a href="#show-commands">SHOW$B%3%^%s%I(B</a></li>
<li><a href="#online-recovery">$B%*%s%i%$%s%j%+%P%j(B</a></li>
<li><a href="#backup">$B%P%C%/%"%C%W(B</a></li>
<li><a href="#deploy">pgpool-II$B$NG[CV$K$D$$$F(B</a></li>
@@ -1947,6 +1948,133 @@ pgpool [-f config_file][-a hba_file][-F pcp_config_file] reload
$B$^$?!"@_Dj$NJQ99$O$9$G$K@\B3Cf$N%;%C%7%g%s$K$OH?1G$5$l$^$;$s!#<!2s!"%/%i%$%"%s%H$,(Bpgpool-II$B$K@\B3$7$?$H$-$+$iH?1G$5$l$^$9!#(B
</p>
+<h1><a name="show-commands"></a>SHOW$B%3%^%s%I(B</h1>
+<h2>$B35MW(B</h2>
+<p>
+pgpool-II$B$G$O!"(BSHOW$B%3%^%s%I$r;H$C$F>pJs$r;2>H$9$k$3$H$,$G$-$^$9!#(B
+SHOW$B$O(BSQL$B%3%^%s%I$G$9$,!"(Bpgpool-II$B$O0lIt$N(BSHOW$B%3%^%s%I$rFH<+$K2r<a$7$F!"(Bpgpool-II$B$,4IM}$9$k>pJs$rJV5Q$7$^$9!#(B
+$B0J2<$N$h$&$J$b$N$,$"$j$^$9!#(B
+<ul>
+ <li>pool_status $B9=@.>pJs(B</li>
+ <li>pool_nodes DB$B%N!<%I>pJs(B</li>
+ <li>pool_processes pgpool-II$B%W%m%;%9$NFbIt>pJs(B</li>
+ <li>pool_pools $B%3%M%/%7%g%s%W!<%k>pJs(B</li>
+ <li>pool_version pgpool-II$B$N%P!<%8%g%s(B</li>
+</ul>
+</p>
+<p>"pool_status" SQL $B$O0JA0$+$i$"$j$^$9$,!"B>$N(BSQL$B$O(Bpgpool-II 3.0$B$+$iDI2C$5$l$^$7$?!#(B
+
+<h2>pool_status</h2>
+<p>"SHOW pool_status" $B$O@_Dj%Q%i%a!<%?$NL>A0$HCM!"@bL@$rI=<($7$^$9!#=PNO$N0lIt$r<($7$^$9!#(B
+<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
+</pre>
+</p>
+<h2>pool_nodes</h2>
+<p>"SHOW pool_nodes"$B$O!"(BDB$B%N!<%I$N%j%9%H$rI=<($7$^$9!#(B
+$B%[%9%HL>!"%]!<%HHV9f!">uBV!"=E$_(B($B%m!<%I%P%i%s%9%b!<%I$G1?MQ$7$F$$$k$H$-$K$N$_0UL#$,$"$j$^$9(B)$B$,I=<($5$l$^$9!#(B
+$B>uBV(B(status)$B$N0UL#$K$D$$$F$O!"(B<a href="#pcp_node_info">pcp_node_info$B%j%U%!%l%s%9(B</a>$B$G@bL@$5$l$F$$$^$9!#(B
+<pre>
+benchs2=# show pool_nodes;
+ hostname | port | status | lb_weight
+-------------+------+--------+-------------------
+ 127.0.0.1 | 5432 | 2 | 1073741823.500000
+ 192.168.1.7 | 5432 | 3 | 1073741823.500000
+(2 lignes)
+</pre>
+</p>
+<h2>pool_processes</h2>
+<p>"SHOW pool_processes"$B$O!"@\B3BT$A!"$"$k$$$O@\B3Cf(Bpgpool-II$B$N;R%W%m%;%9$N>uBV$rI=<($7$^$9!#(B
+</p>
+<p>
+6$B$D$N%+%i%`$,$"$j$^$9!#(B
+<ul>
+<li>pool_pid $B$O(Bpgpool-II$B%W%m%;%9$N%W%m%;%9(BID$B$G$9!#(B</li>
+<li>start_time$B$O$3$N%W%m%;%9$,5/F0$5$l$?;~9o$G$9(B(1970$BG/(B1$B7n(B1$BF|$+$i$N7P2aIC$GI=<($5$l$^$9(B)$B!#(B</li>
+<li>database$B$O$3$N%W%m%;%9$,@\B3$7$F$$$k%G!<%?%Y!<%9L>$G$9!#(B</li>
+<li>username$B$O$3$N%W%m%;%9$N@\B3$G;HMQ$7$F$$$k%f!<%6L>$G$9!#(B</li>
+<li>create_time is$B$O$3$N@\B3$,:n@.$5$l$?;~9o$G$9!#(B</li>
+<li>pool_counter $B$O$3$N@\B3$,;HMQ$5$l$?2s?t$G$9!#(B</li>
+</ul>
+</p>
+<p>$BJV5Q9T?t$O>o$K(Bnum_init_children$B$K$J$j$^$9!#(B
+$B$^$?!"%G!<%?%Y!<%9L>$J$I$,I=<($5$l$k$N$O!"$=$N%W%m%;%9$K%U%m%s%H%(%s%I$+$i$N@\B3$,$"$k>l9g$K8B$j$^$9!#(B</p>
+<pre>
+benchs2=# show pool_processes;
+ pool_pid | start_time | database | username | create_time | pool_counter
+----------+------------+-----------+-----------+-------------+--------------
+ 4318 | 1281433036 | | | |
+ 4319 | 1281433036 | | | |
+ 4320 | 1281433036 | benchs2 | guillaume | 1281433038 | 1
+ 4321 | 1281433036 | | | |
+ 4322 | 1281433036 | | | |
+(5 lines)
+</pre>
+<h2>pool_pools</h2>
+<p>"SHOW pool_pools"$B$O!"(Bpgpool-II$B$N%3%M%/%7%g%s%W!<%k$N>uBV$rI=<($7$^$9!#(B
+</p>
+<p>
+10$B$N%+%i%`$,$"$j$^$9!#(B
+<ul>
+<li>pool_pid $B$O(Bpgpool-II$B%W%m%;%9$N%W%m%;%9(BID$B$G$9!#(B</li>
+<li>start_time$B$O$3$N%W%m%;%9$,5/F0$5$l$?;~9o$G$9(B(1970$BG/(B1$B7n(B1$BF|$+$i$N7P2aIC$GI=<($5$l$^$9(B)$B!#(B</li>
+<li>pool_id $B$O%3%M%/%7%g%s%W!<%k(BID$B$G$9!#(B(0$B$+$i(Bmax_pool-1$B$NCM$G$9(B)</li>
+<li>database$B$O$3$N%W%m%;%9$,@\B3$7$F$$$k%G!<%?%Y!<%9L>$G$9!#(B</li>
+<li>username$B$O$3$N%W%m%;%9$N@\B3$G;HMQ$7$F$$$k%f!<%6L>$G$9!#(B</li>
+<li>create_time is$B$O$3$N@\B3$,:n@.$5$l$?;~9o$G$9!#(B</li>
+<li>majorversion $B$H(B minorversion $B$O$3$N@\B3$G;HMQ$5$l$F$$$k%W%m%H%3%k%P!<%8%g%sHV9f$G$9!#(B</li>
+<li>pool_counter $B$O$3$N@\B3$,;HMQ$5$l$?2s?t$G$9!#(B</li>
+<li>pool_backendpid $B$O(B PostgreSQL $B$N%P%C%/%(%s%I%W%m%;%9$N%W%m%;%9(BID$B$G$9!#(B</li>
+<li>pool_connected $B$O??56CM$G!"(B0$B$J$i%U%m%s%H%(%s%I$+$i$N@\B3L5$7!"(B1$B$J$i@\B3$"$j$rI=$7$^$9!#(B</li>
+</ul>
+</p>
+<p>$BJV5Q9T?t$O>o$K(Bnum_init_children*max_pool$B$K$J$j$^$9!#(B
+<pre>
+benchs2=# show pool_pools;
+ pool_pid | start_time | pool_id | database | username | create_time | majorversion | minorversion | pool_counter | pool_backendpid | pool_connected
+----------+------------+---------+----------+-----------+-------------+--------------+--------------+--------------+-----------------+----------------
+ 4318 | 1281433036 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4318 | 1281433036 | 1 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4318 | 1281433036 | 2 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4318 | 1281433036 | 3 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4319 | 1281433036 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4319 | 1281433036 | 1 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4319 | 1281433036 | 2 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4319 | 1281433036 | 3 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4320 | 1281433036 | 0 | benchs2 | guillaume | 1281433038 | 3 | 0 | 1 | 4327 | 1
+ 4320 | 1281433036 | 1 | | | 0 | 0 | 0 | 0 | 0 | 1
+ 4320 | 1281433036 | 2 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4320 | 1281433036 | 3 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4321 | 1281433036 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4321 | 1281433036 | 1 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4321 | 1281433036 | 2 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4321 | 1281433036 | 3 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4322 | 1281433036 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4322 | 1281433036 | 1 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4322 | 1281433036 | 2 | | | 0 | 0 | 0 | 0 | 0 | 0
+ 4322 | 1281433036 | 3 | | | 0 | 0 | 0 | 0 | 0 | 0
+(20 lines)
+</pre>
+</p>
+<h2>pool_version</h2>
+<p>"SHOW pool_version" $B$O(Bpgpool-II$B$N%P!<%8%g%s>pJs$rI=<($7$^$9!#(B
+$BNc$r<($7$^$9!#(B
+<pre>
+benchs2=# show pool_version;
+ pool_version
+------------------------
+ 3.0-dev (umiyameboshi)
+(1 line)
+</pre>
+</p>
+
<h1><a name="online-recovery"></a>$B%*%s%i%$%s%j%+%P%j(B</h1>
<h2> $B%*%s%i%$%s%j%+%P%j35MW(B</h2>
<p>
@@ -2994,7 +3122,7 @@ configure $B$K<:GT$7$^$9!#I,$:(B libpq 3.0 $B0J9_(B(PostgreSQL 7.4$B0J9_(B
</p>
-<h3>pcp_node_info</h3>
+<h3><a name="pcp_node_info"></a>pcp_node_info</h3>
<pre>
$B=q<0!'(B
pcp_node_info _timeout_ _host_ _port_ _userid_ _passwd_ _nodeid_
[parent: 57217a14fa9b]