pgpool2.git / summary / log / commit / refs

commit    bbe80a770a84c3a72eea5908f1ade60c7bcb4a6b
Author:   Tatsuo Ishii <ishii at sraoss.co.jp>
Date:     Sat Nov 24 13:04:10 2007 +0000

    Fix english docs.
    Add a link to tutorial.


doc/pgpool-en.html | 71 +++++++++++++++++++++++++++++++++++++++--------------- doc/pgpool-ja.html | 12 ++++++--- 2 files changed, 61 insertions(+), 22 deletions(-) diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html index 870ca4b93..5733f67b2 100644 --- a/doc/pgpool-en.html +++ b/doc/pgpool-en.html @@ -6,7 +6,10 @@ <title>pgpool-II README</title> </head> -<!-- hhmts start -->Last modified: Wed Jun 6 17:29:52 JST 2007 <!-- hhmts end --> +<!-- hhmts start --> +Last modified: Sat Nov 24 21:48:54 JST 2007 +<!-- hhmts end --> + <body bgcolor="#ffffff"> <a name="top"></a> <table border="0" cellpadding="2" cellspacing="1"> @@ -35,8 +38,7 @@ <div class="header_small" align="center"> - (last update: 2007/11/17)<br /> - [<a href="http://www2b.biglobe.ne.jp/~caco/pgpool/">Japanese page</a>] </div> </td> + [<a href="pgpool-ja.html">Japanese page</a>] </div> </td> <td valign="top" style="border-left:1px dotted #cccccc;"> @@ -375,7 +377,7 @@ servers.</p> leaks and other unexpected errors. Default value is 300 (5 minutes). 0 disables this function. Note that processes that have not accepted any connections are not applicable for this. - This parameter can be changed on service. + You need to reload pgpool.conf if you change the value. </p> </dd> @@ -385,15 +387,34 @@ servers.</p> connections from clients. This parameter is useful on the server if it is too busy that child_life_time and connection_life_time are not effective. - This parameter can be changed on service. + You need to reload pgpool.conf if you change the value. </p> </dd> + <dt>client_idle_limit + <dd> + <p>Disconnect the connection to a client being idle for + client_idle_limit seconds since the last query has been sent. + This is usefull for preventing for pgpool childs from being + ocuppied by a lazy client or TCP/IP connection between client and + pgpool is accidentally down. The default value for + client_idle_limit is 0, which means the functionality is turned + off. You need to reload pgpool.conf if you change + client_idle_limit.</p> + + <dt>authentication_timeout + <dd> + <p>Specify the timeout for pgpool authentication. 0 disables the time + out, which is the default. You need to restart pgpool-II if you + change authentication_timeout.</p> + <dt>logdir</dt> <dd> <p>The directory path of the logs created by pgpool-II. Currently, only the <code>pgpool.pid</code> file is - created. Default is <code>'/tmp'</code>.</p> + created. Default is <code>'/tmp'</code>. + You need to restart pgpool-II if you change logdir. + </p> </dd> <dt>print_timestamp</dt> @@ -401,6 +422,7 @@ servers.</p> <p>Add timestamps to the logs when set to true. Default is true. This parameter can be changed on service. + You need to reload pgpool.conf if you change print_timestamp. </p> </dd> @@ -426,7 +448,7 @@ servers.</p> backend, so <code>max_connections</code> in the <code>postgresql.conf</code> needs to be incremented as needed. - This parameter can be changed on service. + You need to reload pgpool.conf if you change the value. </p> </dd> @@ -434,13 +456,17 @@ servers.</p> <dd> <p>This parameter specifies the interval between the health checks in seconds. Default is 0, which means health check is - disabled.</p> + disabled. + You need to reload pgpool.conf if you change health_check_period. + </p> </dd> <dt>health_check_user</dt> <dd> <p>The user name to perform health check. This user must exist - in all the PostgreSQL backends.</p> + in all the PostgreSQL backends. + You need to reload pgpool.conf if you change health_check_user. + </p> </dd> <dt>failover_command @@ -461,7 +487,7 @@ pgpool-II replaces special characters to backend information. <tr><td>%%</td><td>'%' character</td></tr> </table> </center> -This parameter can be changed on service. +You need to reload pgpool.conf if you change failover_command. </p> <dt>failback_command @@ -481,7 +507,7 @@ pgpool-II replaces special characters to backend information. <tr><td>%%</td><td>'%' character</td></tr> </table> </center> - This parameter can be changed on service. + You need to reload pgpool.conf if you change failback_command. </p> <dt>ignore_leading_white_space</dt> @@ -489,7 +515,9 @@ pgpool-II replaces special characters to backend information. <p>pgpool-II ignores white spaces at the beginning of SQL queries while in the load balance mode. It is useful for using APIs like DBI/DBD:Pg which adds white spaces against the user's - will. This parameter can be changed on service.</p> + will. + You need to reload pgpool.conf if you change the value. + </p> </dd> <dt>log_statement</dt> @@ -497,7 +525,8 @@ pgpool-II replaces special characters to backend information. <p>Produces SQL log messages when true. This is similar to the log_statement parameter in PostgreSQL. It produces logs even if the debug option was not passed to pgpool-II at startup. - This parameter can be changed on service.</p> + You need to reload pgpool.conf if you change the value. + </p> </dd> <dt>log_hostname</dt> @@ -505,7 +534,7 @@ pgpool-II replaces special characters to backend information. <p> If true, ps command status will show the client's hostname instead of an IP address. Also, if log_connections is enabled, hostname will - be logged. This parameter can be changed on service. + be logged. You need to reload pgpool.conf if you change the value. </p> </dd> @@ -513,7 +542,8 @@ pgpool-II replaces special characters to backend information. <dd> <p> If true, all incoming connections will be printed to the log. - This parameter can be changed on service.</p> + You need to reload pgpool.conf if you change the value. + </p> </dd> <dt>enable_pool_hba</dt> @@ -521,7 +551,7 @@ pgpool-II replaces special characters to backend information. <p> If true, use pool_hba.conf for client authentication. See <a href="#hba"> Setting up pool_hba.conf for client authentication</a>. - This parameter can only be set at server start. + You need to restart pgpool-II if you change the value. </p> </dd> @@ -1957,8 +1987,8 @@ Retrieval system Query (SELECT) The set of data is defined according to the FROM <p> <table border> -<tr><td>JOIN type</td><td align = center colspan = 3> LEFT OUTER JOIN </td><td align = center colspan = 3> RIGHT OUTER JOIN </td><td align = center colspan = 3>FULL OUTER JOIN</td><td align = center colspan = 3>   others   </td></tr> - <tr><td align = center>left\right</td><td> P </td><td> L </td><td> S </td><td> P </td><td> L </td><td> S </td><td> P </td><td> L </td><td> S </td><td> P </td><td> L </td><td> S </td></tr> +<tr><td>JOIN type</td><td align = center colspan = 3> LEFT OUTER JOIN </td><td align = center colspan = 3> RIGHT OUTER JOIN </td><td align = center colspan = 3>FULL OUTER JOIN</td><td align = center colspan = 3>$B!!!!!!(Bothers$B!!!!!!(B</td></tr> + <tr><td align = center>left$B!@(Bright</td><td> P </td><td> L </td><td> S </td><td> P </td><td> L </td><td> S </td><td> P </td><td> L </td><td> S </td><td> P </td><td> L </td><td> S </td></tr> <tr><td align = center> P </td><td> S </td><td> P </td><td> S </td><td> S </td><td> S </td><td> S </td><td> S </td><td> S </td><td> S </td><td> S </td><td> P </td><td> S </td></tr> @@ -2120,7 +2150,10 @@ When the Query is analyzed, the column name and the type are needed in a paralle </table> </p> - +<h1>Tutorial</h1> +<p> +<a href="tutorial-en.html">A tutorial for pgpool-II</a> is available. +</p> </body> </html> diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html index 1eecb6e2a..a8eb27172 100644 --- a/doc/pgpool-ja.html +++ b/doc/pgpool-ja.html @@ -7,7 +7,9 @@ </head> <body> -<!-- hhmts start -->Last modified: Wed Jun 6 17:29:15 JST 2007 <!-- hhmts end --> +<!-- hhmts start --> +Last modified: Sat Nov 24 21:40:03 JST 2007 +<!-- hhmts end --> <body bgcolor="#ffffff"> <a name="top"></a> @@ -38,8 +40,7 @@ <div class="header_small" align="center"> - (last update: 2007/10/04)<br /> - [<a href="http://pgpool.projects.postgresql.org/">English page</a>] </div> </td> + [<a href="pgpool-en.html">English page</a>] </div> </td> <td valign="top" style="border-left:1px dotted #cccccc;"> @@ -2418,6 +2419,11 @@ SELECT$B$N:G=*<B9T%9%F!<%?%9$H%Q%U%)!<%^%s%9$N$*$*$h$=$NL\0B$O0J2<$N$H$*$j$G$9! </p> +<h1>$B%A%e!<%H%j%"%k(B</h1> +<p> +pgpool-II$B$N%A%e!<%H%j%"%k$O(B<a href="tutorial-ja.html">$B$3$3(B<a/>$B$K$"$j$^$9!#@'Hs$4Mw2<$5$$!#(B +</p> + <h1>$B%j%j!<%9%N!<%H(B<a name="release"></a></h1> <h2>2.0.1 (hikitsuboshi) 2007/11/21</h2> [parent: 67458ec12e09]