pgpool2.git / summary / log / commit / refs
commit ae53bcfb69d356ae121f661e4c099833729dbc3e
Author: Tatsuo Ishii <ishii at sraoss.co.jp>
Date: Sun Jan 30 00:23:30 2011 +0000
Add mention about pgpool-walrecrunning.
doc/pgpool-en.html | 34 +++++++++++++++++++++++++++-------
doc/pgpool-ja.html | 27 +++++++++++++++++++++------
2 files changed, 48 insertions(+), 13 deletions(-)
diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html
index 5ce22fcc8..0ef0d1abe 100644
--- a/doc/pgpool-en.html
+++ b/doc/pgpool-en.html
@@ -7,7 +7,7 @@
</head>
<!-- hhmts start -->
-Last modified: Mon Jan 24 13:30:13 JST 2011
+Last modified: Sun Jan 30 09:14:28 JST 2011
<!-- hhmts end -->
<body bgcolor="#ffffff">
@@ -185,17 +185,16 @@ will install pgpool-II. (If you use Solaris or FreeBSD, replace make with gmake)
<dt>Installing pgpool_regclass</dt>
<dd>
<p>
-If you are using PostgreSQL 8.0 or later, installing pgpool_regclass is strongly
-recommended, as it is used internally by pgpool-II.
+If you are using PostgreSQL 8.0 or later, installing pgpool_regclass function on all PostgreSQL to be accessed by pgpool-II is strongly recommended, as it is used internally by pgpool-II.
Without this, handling of duplicate table names in different schema
might cause trouble (temporary tables aren't a problem).
</p>
<p>
<pre>
-# cd pgpool-II-x.x.x/sql/pgpool-regclass
-# make
-# make install
-# psql -f pgpool-regclass.sql template1
+cd pgpool-II-x.x.x/sql/pgpool-regclass
+make
+make install
+psql -f pgpool-regclass.sql template1
</pre>
</p>
<p>
@@ -206,6 +205,27 @@ execution of "psql -f pgpool-regclass.sql template1", as this template database
will be cloned to create new databases.
</p>
+<dt>Installing pgpool_regclass</dt>
+<dd>
+<p>
+If you are using PostgreSQL 9.0 or later along with streaming replication, you need to install pgpool_walrecrunning function on all PostgreSQL to be accessed by pgpool-II.
+</p>
+<p>
+<pre>
+cd pgpool-II-x.x.x/sql/pgpool-walrecrunning
+make
+make install
+psql -f pgpool-walrecrunning.sql template1
+</pre>
+</p>
+<p>
+Executing pgpool-walrecrunning.sql should be performed on every database accessed
+with pgpool-II.
+You do not need to do this for a database created after the
+execution of "psql -f pgpool-regclass.sql template1", as this template database
+will be cloned to create new databases.
+</p>
+
</dl>
<h1>Configuring pgpool-II<a name="config"></a></h1>
diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html
index 5fbb9e3b4..bab54ea60 100644
--- a/doc/pgpool-ja.html
+++ b/doc/pgpool-ja.html
@@ -8,7 +8,7 @@
<body>
<!-- hhmts start -->
-Last modified: Sun Jan 16 19:27:15 JST 2011
+Last modified: Sun Jan 30 09:23:45 JST 2011
<!-- hhmts end -->
<body bgcolor="#ffffff">
@@ -167,18 +167,33 @@ make install
PostgreSQL 8.0$B0J9_$r;HMQ$7$F$$$k>l9g$O!"(Bpgpool-II$B$,FbIt$G;HMQ$9$k(BC$B4X?t(Bpgpool_regclass$B$r%$%s%9%H!<%k$7$^$9!#(B
$B$3$N4X?t$,%$%s%9%H!<%k$5$l$F$$$J$/$F$b(Bpgpool-II$B$OF0:n$7$^$9$,!"0c$&%9%-!<%^$GF1$8%F!<%V%kL>$rDj5A$7$F$$$F!"(BSQL$BJ8$NCf$G%9%-!<%^L>$r>JN,$7$F$$$k>l9g$K!"IT6q9g$,@8$8$k$3$H$,$"$j$^$9(B($B0l;~%F!<%V%k$r=|$/(B)$B!#(B
$B$7$?$,$C$F!"2DG=$J$i$P(Bpgpool_regclass$B$r%$%s%9%H!<%k$9$k$3$H$r$*4+$a$7$^$9!#(B
-
+$B$3$N%$%s%9%H!<%k$O!"(Bpgpool-II$B$,%"%/%;%9$9$kM=Dj$N$9$Y$F$N(BPostgreSQL$B%5!<%P$G<B;\$7$F$/$@$5$$!#(B
<pre>
-# cd pgpool-II-x.x.x/sql/pgpool-regclass
-# make
-# make install
-# psql -f pgpool-regclass.sql template1
+cd pgpool-II-x.x.x/sql/pgpool-regclass
+make
+make install
+psql -f pgpool-regclass.sql template1
</pre>
pgpool-regclass.sql$B$N<B9T$O!"(Bpgpool-II$B7PM3$GMxMQ$9$k%G!<%?%Y!<%9Kh$KI,MW$K$J$j$^$9!#(B
$B$?$@$7!"(B"psql -f pgpool-regclass.sql template1"$B$r<B9T8e$K:n@.$5$l$?%G!<%?%Y!<%9$G$O<+F0E*$K(Bpgpool-regclass.sql$B$NFbMF$,H?1G$5$l$F$$$k$N$G!"?7$?$K(Bpgpool-regclass.sql$B$r<B9T$9$kI,MW$O$"$j$^$;$s!#(B
</p>
+<dt>pgpool_walrecunning$B$N%$%s%9%H!<%k(B
+<dd>
+<p>
+PostgreSQL 9.0$B0J9_$r;HMQ$7$F$$$F!"%9%H%j!<%_%s%0%l%W%j%1!<%7%g%s$rMxMQ$7$?$$>l9g$O!"(BC$B4X?t(Bpgpool_walrecrunning$B$r%$%s%9%H!<%k$7$^$9!#(B
+$B$3$N%$%s%9%H!<%k$O!"(Bpgpool-II$B$,%"%/%;%9$9$kM=Dj$N$9$Y$F$N(BPostgreSQL$B%5!<%P$G<B;\$7$F$/$@$5$$!#(B
+<pre>
+cd pgpool-II-x.x.x/sql/pgpool-walrecrunning
+make
+make install
+psql -f pgpool-walrecrunning.sql template1
+</pre>
+pgpool-walrecrunning.sql$B$N<B9T$O!"(Bpgpool-II$B7PM3$GMxMQ$9$k%G!<%?%Y!<%9Kh$KI,MW$K$J$j$^$9!#(B
+$B$?$@$7!"(B"psql -f pgpool-walrecrunning.sql template1"$B$r<B9T8e$K:n@.$5$l$?%G!<%?%Y!<%9$G$O<+F0E*$K(Bpgpool-walrecrunning.sql$B$NFbMF$,H?1G$5$l$F$$$k$N$G!"?7$?$K(Bpgpool-walrecrunning.sql$B$r<B9T$9$kI,MW$O$"$j$^$;$s!#(B
+</p>
+
</dl>
<p>
$B0J>e$G%$%s%9%H!<%k$,40N;$7$^$9(B(GNU make$B$,I,MW$J$N$G!"(BSolaris$B$d(BFreeBSD$B$J$I$G$O(B
[parent: d12fc14cfb16]