pgpool2.git / summary / log / commit / refs
commit 1a4d2f45fcf44acf3b8889edb27a17e623481f57
Author: Yoshiyuki Asaba <y-asaba at pgfoundry.org>
Date: Wed Oct 31 06:10:13 2007 +0000
Add comments about reloadable derectives.
doc/pgpool-ja.html | 103 ++++++++++++++++++++++++++++++++++++++++++++++++-----
1 file changed, 94 insertions(+), 9 deletions(-)
diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html
index a053f2d4c..72838e3b2 100644
--- a/doc/pgpool-ja.html
+++ b/doc/pgpool-ja.html
@@ -300,13 +300,16 @@ pgpool-II$B$,(BTCP/IP$B%3%M%/%7%g%s$r<u$1IU$1$k%"%I%l%9$r%[%9%HL>$^$?$O(BIP
$B;XDj$7$^$9!%!V(B*$B!W$r;XDj$9$k$H$9$Y$F$N(BIP$B%$%s%?%U%'!<%9$+$i$N%3%M%/%7%g(B
$B%s$r<u$1IU$1$^$9!%!V(B''$B!W$r;XDj$9$k$H(BTCP/IP$B%3%M%/%7%g%s$r<u$1IU$1$^(B
$B$;$s!%%G%U%)%k%HCM$O!V(Blocalhost$B!W$G$9!%(B
-UNIX$B%I%a%$%s%=%1%C%H7PM3$N%3%M%/%7%g%s$O>o$K<u$1IU$1$^$9!%(B
+UNIX$B%I%a%$%s%=%1%C%H7PM3$N%3%M%/%7%g%s$O>o$K<u$1IU$1$^$9!%$3$N%Q%i%a!<(B
+$B%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>port
<dd>
<p>
-pgpool-II$B$,%3%M%/%7%g%s$r<u$1IU$1$k%]!<%HHV9f$G$9!%%G%U%)%k%HCM$O(B9999$B$G$9!%(B
+pgpool-II$B$,%3%M%/%7%g%s$r<u$1IU$1$k%]!<%HHV9f$G$9!%%G%U%)%k%HCM$O(B9999
+$B$G$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>socket_dir
@@ -315,12 +318,14 @@ pgpool-II$B$,%3%M%/%7%g%s$r<u$1IU$1$k%]!<%HHV9f$G$9!%%G%U%)%k%HCM$O(B9999$B$G
pgpool-II$B$,%3%M%/%7%g%s$r<u$1IU$1$k(BUNIX$B%I%a%$%s%=%1%C%H$rCV$/%G%#%l%/%H%j$G$9!%(B
$B%G%U%)%k%HCM$O(B'/tmp'$B$G$9$,!$(Bcron$B$K$h$j>C$5$l$F$7$^$&$3$H$b$"$k$N$G!$$[$+(B
$B$N%G%#%l%/%H%j!$$?$H$($P(B/var/run$B$J$I$KCV$/$3$H$r$*$9$9$a$7$^$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>pcp_port
<dd>
<p>
pcp$B$,;HMQ$9$k%]!<%HHV9f$G$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>pcp_socket_dir
@@ -329,6 +334,7 @@ pcp$B$,;HMQ$9$k%]!<%HHV9f$G$9!%(B
pcp$B$,%3%M%/%7%g%s$r<u$1IU$1$k(BUNIX$B%I%a%$%s%=%1%C%H$rCV$/%G%#%l%/%H%j$G$9!%(B
$B%G%U%)%k%HCM$O(B'/tmp'$B$G$9$,!$(Bcron$B$K$h$j>C$5$l$F$7$^$&$3$H$b$"$k$N$G!$$[$+(B
$B$N%G%#%l%/%H%j!$$?$H$($P(B/var/run$B$J$I$KCV$/$3$H$r$*$9$9$a$7$^$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>backend_socket_dir
@@ -337,6 +343,7 @@ pcp$B$,%3%M%/%7%g%s$r<u$1IU$1$k(BUNIX$B%I%a%$%s%=%1%C%H$rCV$/%G%#%l%/%H%j$G$9
UNIX$B%I%a%$%s%=%1%C%H7PM3$G(Bpgpool-II$B$,(BPostgreSQL$B$H@\B3$9$k:]$K;HMQ$9$k(B
PostgreSQL$B$N(BUNIX$B%I%a%$%s%=%1%C%H$,CV$+$l$F$$$k%G%#%l%/%H%j!%%G%U%)%k%HCM(B
$B$O(B/tmp$B$G$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>pcp_timeout
@@ -344,6 +351,7 @@ PostgreSQL$B$N(BUNIX$B%I%a%$%s%=%1%C%H$,CV$+$l$F$$$k%G%#%l%/%H%j!%%G%U%)%k%HC
<p>
pcp$B$,(Bpgppool$B$H@\B3$9$k:]$N%?%$%`%"%&%HCM!%(B0$B$K$9$k$H%?%$%`%"%&%H$7$^$;$s!%(B
$B%G%U%)%k%HCM$O(B10($BIC(B)$B$G$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>num_init_children
@@ -356,6 +364,7 @@ prefork$B$9$k(Bpgpool-II$B$N%5!<%P%W%m%;%9$N?t$G$9!%%G%U%)%k%HCM$O(B32$B$K$
$BCf$N>l9g$OLd$$9g$o$;$N%-%c%s%;%k$,$G$-$J$/$C$F$7$^$&$N$G!$$4Cm0U2<(B
$B$5$$!%Ld$$9g$o$;$N%-%c%s%;%k$rI,$:J]>Z$7$?$$>l9g$O!$A[Dj$5$l$k%3%M(B
$B%/%7%g%s?t$NG\$NCM$r@_Dj$9$k$3$H$r$*$9$9$a$7$^$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>child_life_time
@@ -367,6 +376,7 @@ prefork$B$9$k(Bpgpool-II$B$N%5!<%P%W%m%;%9$N?t$G$9!%%G%U%)%k%HCM$O(B32$B$K$
$B%U%)%k%HCM$O(B300$BIC!$$9$J$o$A(B5$BJ,$G$9!%(B0$B$r;XDj$9$k$H$3$N5!G=$OF/$-$^$;(B
$B$s!J$9$J$o$A5/F0$7$CJ|$7!K!%$J$*!$$^$@0lEY$b%3%M%/%7%g%s$r(B
$B<u$1IU$1$F$$$J$$%W%m%;%9$K$O(Bchild_life_time$B$OE,MQ$5$l$^$;$s!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>child_max_connections
@@ -376,6 +386,7 @@ prefork$B$9$k(Bpgpool-II$B$N%5!<%P%W%m%;%9$N?t$G$9!%%G%U%)%k%HCM$O(B32$B$K$
$B%;%9$r=*N;$7$^$9!#(Bchild_life_time$B$d(Bconnection_life_time$B$,8z$+$J$$$/(B
$B$i$$K;$7$$%5!<%P$G!"(BPostgreSQL$B%P%C%/%(%s%I$,HnBg2=$9$k$N$rKI$0$N$K(B
$BM-8z$G$9!#(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>client_idle_limit
@@ -385,6 +396,7 @@ prefork$B$9$k(Bpgpool-II$B$N%5!<%P%W%m%;%9$N?t$G$9!%%G%U%)%k%HCM$O(B32$B$K$
$B%/%(%j$,FO$+$J$$>l9g$O!$%/%i%$%"%s%H$X$N@\B3$r6/@)E*$K@ZCG$7!$%/%i%$(B
$B%"%s%H$+$i$N<!$N%3%M%/%7%g%s$rBT$D$h$&$K$7$^$9!#%G%U%)%k%HCM$O(B 0($BL5(B
$B8z(B)$B$G$9!#(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>authentication_timeout
@@ -393,6 +405,7 @@ prefork$B$9$k(Bpgpool-II$B$N%5!<%P%W%m%;%9$N?t$G$9!%%G%U%)%k%HCM$O(B32$B$K$
$BG'>Z=hM}$N%?%$%`%"%&%H;~4V$rICC10L$G;XDj$7$^$9!#(B0 $B$r;XDj$9$k$H%?%$(B
$B%`%"%&%H$rL58z$K$7$^$9!#(Bauthentication_timeout $B$N%G%U%)%k%HCM$O(B 60
$B$G$9!#(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>logdir
@@ -401,6 +414,7 @@ prefork$B$9$k(Bpgpool-II$B$N%5!<%P%W%m%;%9$N?t$G$9!%%G%U%)%k%HCM$O(B32$B$K$
pgpool-II$B$N3F<o%m%0%U%!%$%k$r3JG<$9$k%G%#%l%/%H%j$G$9!%8=:_$N$H$3$m!$(B
pgpool.pid$B$H$$$&%W%m%;%9(BID$B$r3JG<$9$k%U%!%$%k$@$1$,:n$i$l$k$h$&$K$J$C(B
$B$F$$$^$9!%(Blogdir$B$N%G%U%)%k%HCM$O(B'/tmp'$B$G$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>print_timestamp
@@ -408,12 +422,14 @@ prefork$B$9$k(Bpgpool-II$B$N%5!<%P%W%m%;%9$N?t$G$9!%%G%U%)%k%HCM$O(B32$B$K$
<p>
true$B$J$i$P(Bpgpool-II$B$N%m%0$K%?%$%`%9%?%s%W$rDI2C$7$^$9!%%G%U%)%k%H$O(B
true$B$G$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>connection_cache
<dd>
<p>
true$B$J$i%3%M%/%7%g%s$r%-%c%C%7%e$7$^$9!%%G%U%)%k%H$O(Btrue$B$G$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>health_check_timeout
@@ -430,6 +446,8 @@ prefork$B$9$k(Bpgpool-II$B$N%5!<%P%W%m%;%9$N?t$G$9!%%G%U%)%k%HCM$O(B32$B$K$
$B$J$*!$%X%k%9%A%'%C%/$rM-8z$K$9$k$H!$%X%k%9%A%'%C%/$N$?$a$NM>J,$N@\(B
$BB3$,(B1$B$DI,MW$K$J$j$^$9$N$G!$(BPostgreSQL$B$N(Bpostgresql.conf$B$N@_Dj9`L\$N(B
max_connections$B$r>/$/$H$b(B1$BA}$d$9$h$&$K$7$F$/$@$5$$!%(B
+
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>health_check_period
@@ -438,12 +456,14 @@ prefork$B$9$k(Bpgpool-II$B$N%5!<%P%W%m%;%9$N?t$G$9!%%G%U%)%k%HCM$O(B32$B$K$
$B%X%k%9%A%'%C%/$r9T$&4V3V$rICC10L$G;XDj$7$^$9!%(B0$B$r;XDj$9$k$H%X%k%9(B
$B%A%'%C%/$r9T$$$^$;$s!%%G%U%)%k%H$O(B0$B$G$9(B($B$D$^$j%X%k%9%A%'%C%/$r9T$$(B
$B$^$;$s(B)$B!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>health_check_user
<dd>
<p>
$B%X%k%9%A%'%C%/$r9T$&$?$a$N(BPostgreSQL$B%f!<%6L>$G$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>failover_command
@@ -463,6 +483,7 @@ prefork$B$9$k(Bpgpool-II$B$N%5!<%P%W%m%;%9$N?t$G$9!%%G%U%)%k%HCM$O(B32$B$K$
<tr><td>%%</td><td>'%'$BJ8;z(B</td></tr>
</table>
</center>
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>failback_command
@@ -482,6 +503,7 @@ pgpool $B$,I,MW$J>pJs$KCV$-49$($F%3%^%s%I$r<B9T$7$^$9!#(B
<tr><td>%%</td><td>'%'$BJ8;z(B</td></tr>
</table>
</center>
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
@@ -492,6 +514,7 @@ pgpool $B$,I,MW$J>pJs$KCV$-49$($F%3%^%s%I$r<B9T$7$^$9!#(B
$B%Z!<%9$OL5;k$5$l$^$;$s(B)$B!#$3$l$O!"(BDBI/DBD:Pg$B$N$h$&$K!">!<j$K9TF,$K%[(B
$B%o%$%H%9%Z!<%9$rDI2C$9$k$h$&$J(BAPI$B$r;H$$!"%m!<%I%P%i%s%9$7$?$$$H$-$K(B
$BM-8z$G$9!#(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>log_statement
@@ -500,6 +523,7 @@ pgpool $B$,I,MW$J>pJs$KCV$-49$($F%3%^%s%I$r<B9T$7$^$9!#(B
true$B$J$i$P(BSQL$BJ8$r%m%0=PNO$7$^$9!%$3$NLrL\$O(BPostgreSQL$B$N(B
log_statement$B%*%W%7%g%s$H;w$F$$$F!$%G%P%C%0%*%W%7%g%s$,$J$$$H$-$G$b(B
$BLd$$9g$o$;$r%m%0=PNO$7$FD4$Y$k$3$H$,$G$-$k$N$GJXMx$G$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>log_hostname
@@ -508,12 +532,14 @@ pgpool $B$,I,MW$J>pJs$KCV$-49$($F%3%^%s%I$r<B9T$7$^$9!#(B
true$B$J$i$P!$(Bps$B%3%^%s%I$G$N>uBVI=<(;~$K(BIP$B%"%I%l%9$G$O$J$/!$%[%9%HL>(B
$B$rI=<($7$^$9!%$^$?!$(Blog_connections$B$,M-8z$J>l9g$K$O%m%0$K%[%9%HL>$r(B
$B=PNO$7$^$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>log_connections
<dd>
<p>
true$B$J$i$P!"A4$F$N%/%i%$%"%s%H@\B3$r%m%0$X=PNO$7$^$9!#(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>enable_pool_hba
@@ -522,6 +548,7 @@ pgpool $B$,I,MW$J>pJs$KCV$-49$($F%3%^%s%I$r<B9T$7$^$9!#(B
true$B$J$i$P!"(Bpool_hba.conf$B$K=>$C$F%/%i%$%"%s%HG'>Z$r9T$$$^$9!#(B
$B>\:Y$O(B<a href="#hba">$B%/%i%$%"%s%HG'>Z(B(HBA)$B$N$?$a$N(Bpool_hba.conf$B@_Dj(B
$BJ}K!(B</a>$B$r;2>H$7$F$/$@$5$$!#(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>backend_hostname
@@ -539,6 +566,11 @@ DB$B%N!<%I(BID == 0$B$N(BPostgreSQL$B$O!$FCJL$K!V%^%9%?!<(BDB$B!W$H8F$P$l
<p>
1$BBf$7$+(BPostgreSQL$B$r;HMQ$7$J$$>l9g$O!$(B"backend_hostname0"$B$H$7$F$/$@$5$$!%(B
</p>
+<p>
+backend_hostname $B$O?7$7$/DI2C$7$?9T$r@_Dj%U%!%$%k:FFI$_9~$_$GDI2C$9$k(B
+$B$3$H$,$G$-$^$9!#$9$G$K$"$k>pJs$rESCf$GJQ99$9$k$3$H$O$G$-$^$;$s!#JQ99$9(B
+$B$k>l9g$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
+</p>
<dt>backend_port
<dd>
@@ -549,6 +581,13 @@ DB$B%N!<%I(BID == 0$B$N(BPostgreSQL$B$O!$FCJL$K!V%^%9%?!<(BDB$B!W$H8F$P$l
"backend_port0"$B$H$7$F$/$@$5$$!%(B
</p>
+<p>
+backend_port $B$O?7$7$/DI2C$7$?9T$r@_Dj%U%!%$%k:FFI$_9~$_$GDI2C$9$k(B
+$B$3$H$,$G$-$^$9!#$9$G$K$"$k>pJs$rESCf$GJQ99$9$k$3$H$O$G$-$^$;$s!#JQ99$9(B
+$B$k>l9g$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
+</p>
+
+
<dt>backend_weight
<dd>
<p>
@@ -559,6 +598,12 @@ DB$B%N!<%I(BID == 0$B$N(BPostgreSQL$B$O!$FCJL$K!V%^%9%?!<(BDB$B!W$H8F$P$l
$BIi2YJ,;6$r;HMQ$7$J$$>l9g$O!$!V(B1$B!W$r@_Dj$7$F$/$@$5$$!%(B
</p>
+<p>
+backend_weight $B$O?7$7$/DI2C$7$?9T$r@_Dj%U%!%$%k:FFI$_9~$_$GDI2C$9$k(B
+$B$3$H$,$G$-$^$9!#$9$G$K$"$k>pJs$rESCf$GJQ99$9$k$3$H$O$G$-$^$;$s!#JQ99$9(B
+$B$k>l9g$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
+</p>
+
<dt>backend_data_directory
<dd>
<p>
@@ -568,6 +613,12 @@ DB$B%N!<%I(BID == 0$B$N(BPostgreSQL$B$O!$FCJL$K!V%^%9%?!<(BDB$B!W$H8F$P$l
"backend_weight0"$B$H$7$F$/$@$5$$!#(B
</p>
+<p>
+backend_data_directory $B$O?7$7$/DI2C$7$?9T$r@_Dj%U%!%$%k:FFI$_9~$_$GDI2C$9$k(B
+$B$3$H$,$G$-$^$9!#$9$G$K$"$k>pJs$rESCf$GJQ99$9$k$3$H$O$G$-$^$;$s!#JQ99$9(B
+$B$k>l9g$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
+</p>
+
</dl>
<h4>raw$B%b!<%I$K$*$1$k%U%'%$%k%*!<%PF0:n$K$D$$$F(B</h4>
@@ -603,6 +654,8 @@ raw$B%b!<%I$K2C$(!$%3%M%/%7%g%s%W!<%j%s%0$,MxMQ$G$-$k$h$&$K$J$j$^$9!%(B
$B$J$*!$(Bpgpool-II$BA4BN$H$7$F$O!$(Bnum_init_children*max_pool $BJ,$@$1(B
PostgreSQL$B$X$N%3%M%/%7%g%s$,D%$i$l$kE@$KCm0U$7$F$/$@$5$$!%(B
+
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>connection_life_time
@@ -611,6 +664,7 @@ raw$B%b!<%I$K2C$(!$%3%M%/%7%g%s%W!<%j%s%0$,MxMQ$G$-$k$h$&$K$J$j$^$9!%(B
$B%3%M%/%7%g%s%W!<%kCf$N%3%M%/%7%g%s$NM-8z4|4V$rICC10L$G;XDj$7$^$9!%(B0
$B$r;XDj$9$k$HM-8z4|4V$OL58B$K$J$j$^$9!%(Bconnection_life_time$B$N%G%U%)(B
$B%k%HCM$O(B0$B$G$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>reset_query_list
@@ -628,6 +682,9 @@ raw$B%b!<%I$K2C$(!$%3%M%/%7%g%s%W!<%j%s%0$,MxMQ$G$-$k$h$&$K$J$j$^$9!%(B
$B$J$*!$!V(BABORT$B!W$O!$(BPostgreSQL 7.4$B0J>e$G$O%H%i%s%6%/%7%g%s%V%m%C%/$N(B
$BCf$K$$$J$$>l9g$K$OH/9T$5$l$^$;$s!%(B
</p>
+<p>
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
+</p>
</dl>
@@ -648,6 +705,7 @@ raw$B%b!<%I!$%3%M%/%7%g%s%W!<%k%b!<%I$K2C$(!$0J2<$r@_Dj$7$^$9!%(B
<p>
$B%l%W%j%1!<%7%g%s%b!<%I$GF0:n$5$;$k>l9g$O(Btrue$B$r;XDj$7$F$/$@$5$$!%%G(B
$B%U%)%k%HCM$O(Bfalse$B$G$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>replication_strict
@@ -659,6 +717,7 @@ raw$B%b!<%I!$%3%M%/%7%g%s%W!<%k%b!<%I$K2C$(!$0J2<$r@_Dj$7$^$9!%(B
$BDc2<$9$k>l9g$b$"$j$^$9!%(B
$B$3$N%*%W%7%g%s$N%G%U%)%k%HCM$O(Btrue$B$G$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
<p>
<dt>replication_timeout
@@ -667,6 +726,7 @@ raw$B%b!<%I!$%3%M%/%7%g%s%W!<%k%b!<%I$K2C$(!$0J2<$r@_Dj$7$^$9!%(B
replication_strict$B$,(Bfalse$B$N$H$-$K%G%C%I%m%C%/$r4F;k$9$k$?$a$N%?%$%`(B
$B%"%&%H;~4V$r%_%jICC10L$G;XDj$7$^$9!%%G%U%)%k%HCM$O(B5000$B!$$9$J$o$A(B5$BIC(B
$B$G$9!%(B0$B$r;XDj$9$k$H%?%$%`%"%&%H$7$J$/$J$j$^$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>load_balance_mode
@@ -674,6 +734,7 @@ raw$B%b!<%I!$%3%M%/%7%g%s%W!<%k%b!<%I$K2C$(!$0J2<$r@_Dj$7$^$9!%(B
<p>
true$B$r;XDj$9$k$H%l%W%j%1!<%7%g%s%b!<%I$N:]$K!$(BSELECT$BJ8$r%^%9%?$H%;(B
$B%+%s%@%j$N4V$G%m!<%I%P%i%s%9$7$^$9!%%G%U%)%k%HCM$O(Bfalse$B$G$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>replication_stop_on_mismatch
@@ -700,11 +761,14 @@ raw$B%b!<%I!$%3%M%/%7%g%s%W!<%k%b!<%I$K2C$(!$0J2<$r@_Dj$7$^$9!%(B
$B$NCM$,(BDB$B%N!<%I$N4V$G0lCW$7$J$/$J$k$3$H$,$"$j$^$9!%$3$NLdBj$O!$(B
$B3:Ev%F!<%V%k$rL@<(E*$K%m%C%/$9$k$3$H$G2sHr$G$-$^$9(B($B$b$A$m$s%H%i%s%6(B
$B%/%7%g%s$NJBNs<B9T@-$O5>@7$K$J$j$^$9$,(B)$B!%$7$+$7!$$=$N$?$a$K$O!$(B
+</p>
<pre>
INSERT INTO ...
</pre>
+<p>
$B$r(B
+</p>
<pre>
BEGIN;
@@ -713,6 +777,7 @@ raw$B%b!<%I!$%3%M%/%7%g%s%W!<%k%b!<%I$K2C$(!$0J2<$r@_Dj$7$^$9!%(B
COMMIT;
</pre>
+<p>
$B$K=q$-49$($J$1$l$P$J$j$^$;$s!%(Binsert_lock$B$r(Btrue$B$K$9$k$H<+F0E*$K%H%i(B
$B%s%6%/%7%g%s$N3+;O!$%F!<%V%k%m%C%/!$%H%i%s%6%/%7%g%s$N=*N;$r9T$C$F(B
$B$/$l$k$N$G!$$3$&$7$?<j4V$r>J$/$3$H$,$G$-$^$9!J$9$G$K%H%i%s%6%/%7%g(B
@@ -746,15 +811,22 @@ raw$B%b!<%I!$%3%M%/%7%g%s%W!<%k%b!<%I$K2C$(!$0J2<$r@_Dj$7$^$9!%(B
PostgreSQL 8.0$B$G$O(Btransactions, privileges, rules, alter_table$B$,(B
fail$B$7$^$9!%(Brule$B$G$O!$(Bview$B$KBP$7$F(BLOCK$B$r$7$h$&$H$7$F$7$^$&$3$H!$(B
$B$[$+$N$b$N$O(B
+</p>
<pre>
! ERROR: current transaction is aborted, commands ignored until end of transaction block
</pre>
+<p>
$B$H$$$&$h$&$J%a%C%;!<%8$,=P$F$7$^$&$?$a$G$9!%$?$H$($P!$(Btransactions
$B$G$O!$B8:_$7$J$$%F!<%V%k$KBP$7$F(BINSERT$B$r9T$&%F%9%H$,4^$^$l$F$*$j!$(B
pgpool$B$,:G=i$KB8:_$7$J$$%F!<%V%k$KBP$7$F(BLOCK$B$r9T$&7k2L!$%(%i!<$K$J$C(B
$B$F%H%i%s%6%/%7%g%s$,%"%\!<%H>uBV$K$J$j!$B3$/(BINSERT$B$G>e5-%(%i!<$,=P(B
$B$F$7$^$$$^$9!%(B
+</p>
+
+<p>
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
+</p>
</dl>
@@ -762,12 +834,14 @@ raw$B%b!<%I!$%3%M%/%7%g%s%W!<%k%b!<%I$K2C$(!$0J2<$r@_Dj$7$^$9!%(B
<dd>
<p>
$B%*%s%i%$%s%j%+%P%j$r9T$&$?$a$N(B PostgreSQL $B%f!<%6L>$G$9!#(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>recovery_password
<dd>
<p>
$B%*%s%i%$%s%j%+%P%j$r9T$&$?$a$N(B PostgreSQL $B%f!<%6%Q%9%o!<%I$G$9!#(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
</p>
<dt>recovery_1st_stage_command
@@ -783,6 +857,9 @@ raw$B%b!<%I!$%3%M%/%7%g%s%W!<%k%b!<%I$K2C$(!$0J2<$r@_Dj$7$^$9!%(B
recovery_1st_stage_command $B$r<B9T$7$F$$$k4V$O(B pgpool $B$G$O%/%i%$%"%s(B
$B%H$+$i$N@\B3$r(B<b>$B@)8B$7$^$;$s(B</b>$B!#;2>H$d99?7$r9T$&$3$H$,$G$-$^$9!#(B
</p>
+<p>
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
+</p>
<dt>recovery_2nd_stage_command
<dd>
@@ -800,6 +877,9 @@ raw$B%b!<%I!$%3%M%/%7%g%s%W!<%k%b!<%I$K2C$(!$0J2<$r@_Dj$7$^$9!%(B
$B%3%^%s%I$r5/F0$7$^$;$s!#@\B3$r@)8B$7!"8=:_$N@\B3?t$,(B 0 $B$K$J$C$?;~E@(B
$B$G%3%^%s%I$r5/F0$7$^$9!#(B
</p>
+<p>
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O@_Dj%U%!%$%k$r:FFI$_9~$_$7$F$/$@$5$$!#(B
+</p>
<h4>$B%m!<%I%P%i%s%9$N>r7o$K$D$$$F(B</h4>
<p>
@@ -860,12 +940,16 @@ DELETE $B$N99?77o?t$,$9$Y$F$N%N!<%I$,F1$8$G$J$$>l9g$O%H%i%s%6%/%7%g%s$r(B
<p>
$B%^%9%?!<%9%l!<%V%b!<%I$G$O!$(Bpgpool.conf$B$N(Breplication_mode$B$r(Bfalse$B$K!$(Bmaster_slave_mode
$B$r(Btrue$B$K$7$^$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<h3>$B%Q%i%l%k%b!<%I(B</h3>
<p>
$B%Q%i%l%k%/%(%j5!G=$,MxMQ$G$-$k%b!<%I$G$9!%%l%W%j%1!<%7%g%s$dIi2YJ,;65!G=(B
$B$OMxMQ$G$-$^$;$s!%(B
+$B%Q%i%l%k%b!<%I$G$O!$(Bpgpool.conf$B$N(Breplication_mode$B$H(Bmaster_slave $B$r(B
+false$B$K$7!"(Bparallel_mode $B$r(Btrue$B$K$7$^$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<h4>$B%7%9%F%`(BDB$B$N@_Dj(B</h4>
<p>
@@ -882,12 +966,14 @@ PostgreSQL$B$N%F!<%V%k$N7A$GJ];}$7$^$9!%%7%9%F%`(BDB$B$O(Bpgpool$B$,F0:n$9$
<p>
$B%7%9%F%`(BDB$B$,F0$$$F$$$k%[%9%HL>$G$9!%6uJ8;z$r;XDj$9$k$H!$(BUNIX$B%I%a%$%s%=%1%C(B
$B%H$G@\B3$7$^$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>system_db_port
<dd>
<p>
-$B%7%9%F%`(BDB$B$N%]!<%HHV9f$G$9!%(B
+$B%7%9%F%`(BDB$B$N%]!<%HHV9f$G$9!%$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II
+$B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>system_dbname
@@ -896,6 +982,7 @@ PostgreSQL$B$N%F!<%V%k$N7A$GJ];}$7$^$9!%%7%9%F%`(BDB$B$O(Bpgpool$B$,F0:n$9$
$B%7%9%F%`(BDB$B$O@lMQ$N%G!<%?%Y!<%9$K@_CV$7$^$9!%$=$N%G!<%?%Y!<%9L>$r;XDj$7$^$9!%(B
$B$3$N%G!<%?%Y!<%9$O$"$i$+$8$aB8:_$7$J$1$l$P$J$j$^$;$s!%$3$3$G$O!$(B
"pgpool"$B$H$$$&%G!<%?%Y!<%9L>$K$9$k$b$N$H$7$^$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>system_db_schema
@@ -904,12 +991,14 @@ PostgreSQL$B$N%F!<%V%k$N7A$GJ];}$7$^$9!%%7%9%F%`(BDB$B$O(Bpgpool$B$,F0:n$9$
$B%7%9%F%`(BDB$B$O@lMQ$N%9%-!<%^$K@_CV$7$^$9!%$=$N%9%-!<%^L>$r;XDj$7$^$9!%(B
$B$3$N%9%-!<%^$O$"$i$+$8$aB8:_$7$J$1$l$P$J$j$^$;$s!%$3$3$G$O!$(B
"pgpool_catalog"$B$H$$$&%9%-!<%^$K$9$k$b$N$H$7$^$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>system_db_user
<dd>
<p>
-$B%7%9%F%`(BDB$B$K@\B3$9$k$H$-$N%f!<%6L>$G$9!%!!(B
+$B%7%9%F%`(BDB$B$K@\B3$9$k$H$-$N%f!<%6L>$G$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
<dt>system_db_password
@@ -917,6 +1006,7 @@ PostgreSQL$B$N%F!<%V%k$N7A$GJ];}$7$^$9!%%7%9%F%`(BDB$B$O(Bpgpool$B$,F0:n$9$
<p>
$B%7%9%F%`(BDB$B$K@\B3$9$k$H$-$N%Q%9%o!<%I$G$9!%%Q%9%o!<%I$r@_Dj$7$F$$$J$$>l9g(B
$B$O6uJ8;z$K$7$F$*$-$^$9!%(B
+$B$3$N%Q%i%a!<%?$rJQ99$7$?;~$K$O(B pgpool-II $B$r:F5/F0$7$F$/$@$5$$!#(B
</p>
</dl>
@@ -1408,11 +1498,6 @@ pgpool $B4IM}%D!<%k$+$i<B9T$7$F$/$@$5$$!#(B
<li>$B%l%W%j%1!<%7%g%s%b!<%I$^$?%^%9%?(B/$B%9%l!<%V%b!<%I;~$K$O(Btrust, reject, clear
text password, pam, $BG'>ZJ}<0$@$1$,MxMQ$G$-$^$9!%(Bmd5$BG'>Z!$(Bcrypt$BG'>Z$J$I$NG'>ZJ}<0$OMxMQ$G$-$^$;$s!%(B
<li>$B$=$l0J30$N%b!<%I$G$O!$(Btrust, reject, clear text password, pam, crypt, md5$BG'>ZJ}<0$@$1$,MxMQ$G$-$^$9!%(B
-<li>pgpool-II$B<+BN$K(Bpg_hba.conf$B$K$h$k%"%/%;%9@)8B$O$+$+$j$^$;$s!%(B
- TCP/IP$B%3%M%/%7%g%s$r5v2D$7$F$$$k>l9g!$(Bpgpool-II$B<+BN$K$O$I$N%[%9%H$+(B
- $B$i$G$b@\B3$G$-$F$7$^$$$^$9!%I,MW$J$i$P(Biptables$B$J$I$r;H$C$F%"%/(B
- $B%;%9@)8B$r$+$1$F2<$5$$(B($B$b$A$m$s!$(Bpgpool-II$B$,@\B3$9$k(BPostgreSQL$B%5!<(B
- $B%P$G$O(Bpg_hba.conf$B$K$h$k%"%/%;%9@)8B$,M-8z$G$9(B)$B!%(B
</ul>
</p>
[parent: 49001d6cc4e2]