pgpool2.git / summary / log / commit / refs

commit    a227be5f95408e63d7463a065e1633d0868ca7c1
Author:   Toshihiro Kitagawa <kitagawa at sraoss.co.jp>
Date:     Fri Aug 13 00:28:14 2010 +0000

    Update sample file pgpool_recovery_pitr.


 doc/pgpool-en.html          | 3 ++-
 sample/pgpool_recovery_pitr | 3 ++-
 2 files changed, 4 insertions(+), 2 deletions(-)

diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html
index f92238cfd..0adf44261 100644
--- a/doc/pgpool-en.html
+++ b/doc/pgpool-en.html
@@ -1972,6 +1972,7 @@ datadir=$1		# master dabatase cluster
 DEST=$2			# hostname of the DB node to be recovered
 DESTDIR=$3		# database cluster of the DB node to be recovered
 port=5432		# PostgreSQL port number
+archdir=/data/archive_log	# archive log directory
 
 # Force to flush current value of sequences to xlog 
 psql -p $port -t -c 'SELECT datname FROM pg_database WHERE NOT datistemplate AND datallowconn' template1|
@@ -1982,7 +1983,7 @@ do
   fi
 done
 
-psql -p $port -c 'SELECT pgpool_switch_xlog()' postgres
+psql -p $port -c "SELECT pgpool_switch_xlog('$archdir')" template1
 </pre>
 </p>
 
diff --git a/sample/pgpool_recovery_pitr b/sample/pgpool_recovery_pitr
index 670f491d9..090041204 100644
--- a/sample/pgpool_recovery_pitr
+++ b/sample/pgpool_recovery_pitr
@@ -5,6 +5,7 @@ datadir=$1		# master dabatase cluster
 DEST=$2			# hostname of the DB node to be recovered
 DESTDIR=$3		# database cluster of the DB node to be recovered
 port=5432		# PostgreSQL port number
+archdir=/data/archive_log	# archive log directory
 
 # Force to flush current value of sequences to xlog 
 psql -p $port -t -c 'SELECT datname FROM pg_database WHERE NOT datistemplate AND datallowconn' template1|
@@ -15,4 +16,4 @@ do
   fi
 done
 
-psql -p $port -c 'SELECT pg_switch_xlog()' postgres
+psql -p $port -c "SELECT pgpool_switch_xlog('$archdir')" template1


[parent: a68d26905f14]