pgpool2.git / summary / log / commit / refs

commit    fd7e8cf104a426655c85f9d07829c65fbda9bd1c
Author:   Toshihiro Kitagawa <kitagawa at sraoss.co.jp>
Date:     Fri Apr 22 01:09:03 2011 +0000

    Add description about follow_master_command


 doc/pgpool-en.html | 37 +++++++++++++++++++++++++++++++++++--
 doc/pgpool-ja.html | 28 ++++++++++++++++++++++++++++
 2 files changed, 63 insertions(+), 2 deletions(-)

diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html
index 4cbd23d41..1721a35ba 100644
--- a/doc/pgpool-en.html
+++ b/doc/pgpool-en.html
@@ -609,7 +609,7 @@ max_pool*num_init_children*2 <= (max_connections - superuser_reserved_connection
        </p>
   </dd>
 
-<dt>failover_command
+<dt>failover_command</dt>
 <dd>
 <p>
 This parameter specifies a command to run when a node is detached.
@@ -643,7 +643,7 @@ After this, pgpool starts new child processes and is ready again to accept
 connections from clients.
 </p>
 
-<dt>failback_command
+<dt>failback_command</dt>
 <dd>
 <p>
 This parameter specifies a command to run when a node is attached.
@@ -668,6 +668,39 @@ information.
       You need to reload pgpool.conf if you change failback_command.
 </p>
 
+<dt>follow_master_command</dt>
+<dd>
+<p>
+This parameter specifies a command to run in master/slave streaming replication mode only after a master failover.
+pgpool-II replaces the following special characters with backend specific information.
+</p>
+
+<blockquote>
+<table border>
+<tr><td>Special character</td><td>Description</td></tr>
+<tr><td>%d</td><td>Backend ID of a detached node.</td></tr>
+<tr><td>%h</td><td>Hostname of a detached node.</td></tr>
+<tr><td>%p</td><td>Port number of a detached node.</td></tr>
+<tr><td>%D</td><td>Database cluster directory of a detached node.</td></tr>
+<tr><td>%M</td><td>Old master node ID.</td></tr>
+<tr><td>%m</td><td>New master node ID.</td></tr>
+<tr><td>%H</td><td>Hostname of the new master node.</td></tr>
+<tr><td>%P</td><td>Old primary node ID.</td></tr>
+<tr><td>%%</td><td>'%' character</td></tr>
+</table>
+</blockquote>
+<p>
+You need to reload pgpool.conf if you change follow_master_command.
+</p>
+
+<p>
+If follow_master_command is not empty, when a master failover is completed in master/slave streaming replication,
+pgpool degenerate all nodes excepted the new master and starts new child processes to be ready again to accept
+connections from clients. After this, pgpool run the command set into the 'follow_master_command' for each
+degenerated nodes. Typically the command should be used to recover the slave from the new master by call the
+pcp_recovery_node command for example.
+</p>
+
   <dt>fail_over_on_backend_error</dt>
   <dd>
       <p>
diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html
index 0c86d02dc..8a75a92ec 100644
--- a/doc/pgpool-ja.html
+++ b/doc/pgpool-ja.html
@@ -627,6 +627,34 @@ pgpool $B$,I,MW$J>pJs$KCV$-49$($F%3%^%s%I$r<B9T$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>follow_master_command
+<dd>
+<p>
+$B%^%9%?!<%N!<%I$N%U%'%$%k%*!<%P!<8e$K<B9T$9$k%3%^%s%I$r;XDj$7$^$9!#(B
+$B$3$l$O!"%^%9%?!<%9%l!<%V%b!<%I$G%9%H%j!<%_%s%0%l%W%j%1!<%7%g%s9=@.$N>l9g$N$_M-8z$G$9!#(B
+$BFC<lJ8;z$r;XDj$9$k$H!"(Bpgpool $B$,I,MW$J>pJs$KCV$-49$($F%3%^%s%I$r<B9T$7$^$9!#(B
+
+<center>
+<table border>
+<tr><td>$BJ8;z(B</td><td>$B0UL#(B</td></tr>
+<tr><td>%d</td><td>$B@Z$jN%$5$l$?%N!<%IHV9f(B</td></tr>
+<tr><td>%h</td><td>$B@Z$jN%$5$l$?%N!<%I$N%[%9%HL>(B</td></tr>
+<tr><td>%p</td><td>$B@Z$jN%$5$l$?%N!<%I$N%]!<%HHV9f(B</td></tr>
+<tr><td>%D</td><td>$B@Z$jN%$5$l$?%N!<%I$N%G!<%?%Y!<%9%/%i%9%?%Q%9(B</td></tr>
+<tr><td>%M</td><td>$B8E$$%^%9%?!<$N%N!<%IHV9f(B</td></tr>
+<tr><td>%m</td><td>$B?7$7$$%^%9%?!<$N%N!<%IHV9f(B</td></tr>
+<tr><td>%H</td><td>$B?7$7$$%^%9%?!<$N%[%9%HL>(B</td></tr>
+<tr><td>%P</td><td>$B8E$$%W%i%$%^%j%N!<%IHV9f(B</td></tr>
+<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>
+
+<p>
+$B6uJ8;zNs0J30$r;XDj$9$k$H!"%^%9%?!<%N!<%I$N%U%'%$%k%*!<%P!<8e$K?7$7$$%^%9%?!<0J30$N$9$Y$F$N%N!<%I$O@Z$jN%$5$l!"%/%i%$%"%s%H$+$i:F$S@\B3$r<u$1IU$1$k$?$a$K;R%W%m%;%9$N:F5/F0$,9T$o$l$^$9!#$=$N8e!"@Z$jN%$5$l$?$=$l$>$l$N%N!<%I$KBP$7$F(Bfollow_master_command$B$K;XDj$7$?%3%^%s%I$,<B9T$5$l$^$9!#DL>o$O!"$3$3$K(Bpcp_recovery_node$B%3%^%s%I$rAH$_9~$s$@%7%'%k%9%/%j%W%H$J$I$r;XDj$7!"?7$7$$%^%9%?!<$+$i%9%l!<%V$r%j%+%P%j$9$k$?$a$K;HMQ$7$^$9!#(B
+</p>
+
 <dt>fail_over_on_backend_error
 <dd>
 <p>


[parent: 2bf76e6aff0b]