pgpool2.git / summary / log / commit / refs
commit a2b814b4b1afd6c0106c2642db461b49deddfd85
Author: Tatsuo Ishii <ishii at sraoss.co.jp>
Date: Sun Jun 13 23:53:25 2010 +0000
Add description of client_idle_limit_in_recover = -1 case.
doc/pgpool-en.html | 9 +++++----
doc/pgpool-ja.html | 6 ++++--
pgpool.conf.sample | 6 ++++--
pgpool.conf.sample-master-slave | 6 ++++--
pgpool.conf.sample-replication | 6 ++++--
5 files changed, 21 insertions(+), 12 deletions(-)
diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html
index c1e7fcc15..8282b7384 100644
--- a/doc/pgpool-en.html
+++ b/doc/pgpool-en.html
@@ -7,7 +7,7 @@
</head>
<!-- hhmts start -->
-Last modified: Wed Jun 9 20:23:10 JST 2010
+Last modified: Mon Jun 14 08:48:48 JST 2010
<!-- hhmts end -->
<body bgcolor="#ffffff">
@@ -1042,9 +1042,10 @@ It can be changed on service.
client_idle_limit_in_recovery seconds since the last query has
been sent. This is usefull for preventing for pgpool recovery
disturbed by a lazy client or TCP/IP connection between client and
- pgpool is accidentally down. The default value for
- client_idle_limit_in_recovery is 0, which means the functionality is turned
- off.
+ pgpool is accidentally down.
+ If -1 specified, disconnect the connection to a client immediately.
+ The default value for client_idle_limit_in_recovery is 0,
+ which means the functionality is turned off.
</p>
<p>
If your clients are very busy, pgpool-II cannot enter the recovery 2nd stage regardless of the value of client_idle_limit_in_recovery. In this case you can set -1 to client_idle_limit_in_recovery so that pgpool-II immediately disconnect such busy clients before entering the 2nd stage.
diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html
index 2caba7d49..2d6ea9331 100644
--- a/doc/pgpool-ja.html
+++ b/doc/pgpool-ja.html
@@ -8,7 +8,7 @@
<body>
<!-- hhmts start -->
-Last modified: Wed Jun 9 20:30:34 JST 2010
+Last modified: Mon Jun 14 08:49:29 JST 2010
<!-- hhmts end -->
<body bgcolor="#ffffff">
@@ -1047,7 +1047,9 @@ recovery_timeout$B$r(B0$B$H$7$F$b%?%$%`%"%&%H$,L58z$K$J$k$o$1$G$O$J$/!"C1$KB(
$B%F!<%8$G$N$_8zNO$,$"$j$^$9!#A02s%/%i%$%"%s%H$+$iMh$?%/%(%j$+$i!"(B
client_idle_limit_in_recovery $BIC1[$($F$b<!$N%/%(%j$,FO$+$J$$>l9g$O!"%/(B
$B%i%$%"%s%H$X$N@\B3$r6/@)E*$K@ZCG$7!"(B
- $B%j%+%P%j$N%;%+%s%I%9%F!<%8$N?J9T$,K832$5$l$k$N$rKI$.$^$9!#%G%U%)%k%HCM$O(B 0($BL58z(B)$B$G$9!#(B
+ $B%j%+%P%j$N%;%+%s%I%9%F!<%8$N?J9T$,K832$5$l$k$N$rKI$.$^$9!#(B
+ -1$B$r;XDj$9$k$H!"D>$A$K%/%i%$%"%s%H$X$N@\B3$r@ZCG$7$F%;%+%s%I%9%F!<%8$KF~$j$^$9!#(B
+ $B%G%U%)%k%HCM$O(B 0($BL58z(B)$B$G$9!#(B
</p>
<p>
$B%/%i%$%"%s%H$,K;$7$/!"%"%$%I%k>uBV$K$J$i$J$$>l9g$O(Bclient_idle_limit_in_recovery$B$r@_Dj$7$F$b%;%+%s%I%9%F!<%8$K0\9T$G$-$^$;$s!#(B
diff --git a/pgpool.conf.sample b/pgpool.conf.sample
index 4255aaa09..f86e943b9 100644
--- a/pgpool.conf.sample
+++ b/pgpool.conf.sample
@@ -214,8 +214,10 @@ recovery_timeout = 90
# If client_idle_limit_in_recovery is n (n > 0), the client is forced
# to be disconnected whenever after n seconds idle (even inside an
-# explicit transactions!) 0 means no disconnect. This parameter only
-# takes effect in recovery 2nd stage.
+# explicit transactions!) in the second stage of online recovery.
+# n = -1 forces clients to be disconnected immediately.
+# 0 disables this functionality(wait forever).
+# This parameter only takes effect in recovery 2nd stage.
client_idle_limit_in_recovery = 0
# Specify table name to lock. This is used when rewriting lo_creat
diff --git a/pgpool.conf.sample-master-slave b/pgpool.conf.sample-master-slave
index fb47900fe..604653389 100644
--- a/pgpool.conf.sample-master-slave
+++ b/pgpool.conf.sample-master-slave
@@ -214,8 +214,10 @@ recovery_timeout = 90
# If client_idle_limit_in_recovery is n (n > 0), the client is forced
# to be disconnected whenever after n seconds idle (even inside an
-# explicit transactions!) 0 means no disconnect. This parameter only
-# takes effect in recovery 2nd stage.
+# explicit transactions!) in the second stage of online recovery.
+# n = -1 forces clients to be disconnected immediately.
+# 0 disables this functionality(wait forever).
+# This parameter only takes effect in recovery 2nd stage.
client_idle_limit_in_recovery = 0
# Specify table name to lock. This is used when rewriting lo_creat
diff --git a/pgpool.conf.sample-replication b/pgpool.conf.sample-replication
index d181ed8e2..ce5e21ef4 100644
--- a/pgpool.conf.sample-replication
+++ b/pgpool.conf.sample-replication
@@ -214,8 +214,10 @@ recovery_timeout = 90
# If client_idle_limit_in_recovery is n (n > 0), the client is forced
# to be disconnected whenever after n seconds idle (even inside an
-# explicit transactions!) 0 means no disconnect. This parameter only
-# takes effect in recovery 2nd stage.
+# explicit transactions!) in the second stage of online recovery.
+# n = -1 forces clients to be disconnected immediately.
+# 0 disables this functionality(wait forever).
+# This parameter only takes effect in recovery 2nd stage.
client_idle_limit_in_recovery = 0
# Specify table name to lock. This is used when rewriting lo_creat
[parent: 2822ff3a4abd]