pgpool2.git / summary / log / commit / refs

commit    5548f82a93282a98b24da2fa1bbf1f7665eae610
Author:   Yoshiyuki Asaba <y-asaba at pgfoundry.org>
Date:     Fri Nov 16 01:39:47 2007 +0000

    - Fix the sample script of online recovery.
    - Add note about timeout of pcp_recovery_node.


 doc/pgpool-en.html | 20 ++++++++++++++++++++
 doc/pgpool-ja.html | 23 +++++++++++++++++++++--
 2 files changed, 41 insertions(+), 2 deletions(-)

diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html
index 8ae785c5f..bda51f1f0 100644
--- a/doc/pgpool-en.html
+++ b/doc/pgpool-en.html
@@ -1298,10 +1298,23 @@ So you need to connect over ssh without pass .
 </p>
 
 <p>
+If you recover with PITR, you need to expand a base backup. Then,
 postmaster automatically starts up with PITR. Then it accepts
 connections.
 </p>
 
+<pre>
+#! /bin/sh
+DEST=$1
+DESTDIR=$2
+PGCTL=/usr/local/pgsql/bin/pg_ctl
+
+# Expand a base backup
+ssh -T $DEST 'cd /data/; tar zxf pgsql.tar.gz' 2>/dev/null 1>/dev/null < /dev/null
+# Startup PostgreSQL server
+ssh -T $DEST $PGCTL -w -D $DESTDIR start 2>/dev/null 1>/dev/null < /dev/null &
+</pre>
+
 <h3>Online recovery with rsync.</h3>
 <p>
 PostgreSQL 7.4 does not have PITR. So we use rsync to do online
@@ -1337,6 +1350,13 @@ For doing online recovery, you use pcp_recovery_node command or
 operate on pgpoolAdmin.
 </p>
 
+<p>
+Note that you need to pass a greater number to the first argument of
+pcp_recovery_node. It is a timeout parameter. If you use pgpoolAdmin, 
+set "_PGPOOL2_PCP_TIMEOUT " parameter to a greater number in
+pgmgt.conf.php.
+</p>
+
 
 <h1>Restrictions<a name="restriction"></a></h1>
 <p>
diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html
index 28958f868..eb516d3bc 100644
--- a/doc/pgpool-ja.html
+++ b/doc/pgpool-ja.html
@@ -1467,10 +1467,23 @@ pgpool $B$+$i$O0J2<$N7A<0$G%9%/%j%W%H$r<B9T$7$^$9!#(B
 </p>
 
 <p>
-PITR $B$K$h$k%j%+%P%j$G$"$l$P!"(Brecovery.conf $B$NFbMF$K$7$?$,$C$F%j%+%P%j(B
-$B$7$?8e$K(B postmaster $B$,@\B32DG=>uBV$K$J$j$^$9!#(B
+PITR $B$K$h$k%j%+%P%j$G$"$l$P!"(Bpgpool_remote_start $BFb$G%Y!<%9%P%C%/%"%C(B
+$B%W$rE83+$7!"(Brecovery.conf $B$NFbMF$K$7$?$,$C$F%j%+%P%j$7$?8e$K(B
+postmaster $B$,@\B32DG=>uBV$K$J$j$^$9!#(B
 </p>
 
+<pre>
+#! /bin/sh
+DEST=$1
+DESTDIR=$2
+PGCTL=/usr/local/pgsql/bin/pg_ctl
+
+# Expand a base backup
+ssh -T $DEST 'cd /data/; tar zxf pgsql.tar.gz' 2>/dev/null 1>/dev/null < /dev/null
+# Startup PostgreSQL server
+ssh -T $DEST $PGCTL -w -D $DESTDIR start 2>/dev/null 1>/dev/null < /dev/null &
+</pre>
+
 <h3>rsync $B$K$h$k%j%+%P%j(B </h3>
 <p>
 7.4 $B0JA0$N>l9g$O(B PITR $B5!G=$,$"$j$^$;$s!#$=$3$G(B PITR $B$r;H$o$:$K(B rsync
@@ -1509,6 +1522,12 @@ recovery_2nd_stage_command = 'pgpool_recovery'
 pgpool $B4IM}%D!<%k$+$i<B9T$7$F$/$@$5$$!#(B
 </p>
 
+<p>
+$BCm0UE@$H$7$F!"(Bpcp_recovery_node $B$r<B9T$9$k:]$K!"%?%$%`%"%&%H$rD9$/$7$F(B
+$B$/$@$5$$!#(BpgpoolAdmin $B$+$i<B9T$9$k>l9g$O(B pgmgt.conf.php $BFb$N(B
+_PGPOOL2_PCP_TIMEOUT $B$rBg$-$/$7$F$/$@$5$$!#(B
+</p>
+
 
 <h1>$B@)8B;v9`(B<a name="restriction"></a></h1>
 <p>


[parent: 3fa34fa0f5e2]