pgpool2.git / summary / log / commit / refs
commit 2bcc61555130179e234e902b63e050812666bad0
Author: Yoshiyuki Asaba <y-asaba at pgfoundry.org>
Date: Fri Mar 14 06:53:49 2008 +0000
Updated English documentation.
doc/pgpool-en.html | 35 +++++++++++++++++++++++++++++++++--
1 file changed, 33 insertions(+), 2 deletions(-)
diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html
index 9fdb05637..101a178f2 100644
--- a/doc/pgpool-en.html
+++ b/doc/pgpool-en.html
@@ -272,6 +272,13 @@ username:[password encrypted in md5]
<code>$prefix/bin/pg_md5</code> command.
</p>
+<pre>
+pg_md5 -p
+password: <your password>
+</pre>
+
+or
+
<pre>
./pg_md5 foo
acbd18db4cc2f85cedef654fccc4a4d8
@@ -839,6 +846,21 @@ connects to pgpool-II.
It can be changed on service.
</p>
+<dt>recovery_timeout
+<dd>
+<p>
+pgpool does not accept connections at second stage. If a client
+connect to pgpool during recovery processing, pgpool wait to be
+close.
+</p>
+<p>
+This parameter specifies recovery timeout in sec. If timeout, pgpool
+cancels online recovery and accepts connections. 0 means no wait.
+</p>
+<p>
+It can be changed on service.
+</p>
+
</dl>
<h4><p>condition for load balance</p></h4>
@@ -856,6 +878,12 @@ For the query to be load balanced, all the requirements below
ignore leading white space)
</ul>
+<p>
+Note: JDBC driver has autocommit option. If autocommit is false, JDBC driver
+send "BEGIN" and "COMMIT" internally. So pgpool cannot load balancing.
+You need to call setAutoCommit(true) to enable autocommit.
+</p>
+
<h4><p>Failover in the Replication Mode</p></h4>
<p> pgpool-II degenerates a dead backend and continues the
@@ -1290,12 +1318,15 @@ recovery target node on the first stage. The script is named
<pre>
#! /bin/sh
+ DATA=$1
+ RECOVERY_TARGET=$2
+ RECOVERY_DATA=$3
psql -c "select pg_start_backup('pgpool-recovery')" postgres
- echo "restore_command = 'scp master:/data/archive_log/%f %p'" > /data/recovery.conf
+ echo "restore_command = 'scp $HOSTNAME:/data/archive_log/%f %p'" > /data/recovery.conf
tar -C /data -zcf pgsql.tar.gz pgsql
psql -c 'select pg_stop_backup()' postgres
- scp pgsql.tar.gz secondary:/data
+ scp pgsql.tar.gz $RECOVERY_TARGET:$RECOVERY_DATA
</pre>
<p>
[parent: da7f23609815]