pgpool2.git / summary / log / commit / refs
commit bead80eb299a323ec4c2fdb19f664ef9c0a083fd
Author: Yugo Nagata <nagata@sraoss.co.jp>
Date: Wed Feb 06 11:10:57 2013 +0000
Modify pgpool.conf.sample* and documents to correct information of
whether a certain parameter change requires restart.
doc/pgpool-en.html | 53 ++++++++++++++++++++++++++++++--------
doc/pgpool-ja.html | 56 +++++++++++++++++++++++++++++++----------
doc/tutorial-memqcache-en.html | 8 ++----
doc/tutorial-memqcache-ja.html | 10 ++------
pgpool.conf.sample | 24 ++++++++++++++++++
pgpool.conf.sample-master-slave | 24 ++++++++++++++++++
pgpool.conf.sample-replication | 24 ++++++++++++++++++
pgpool.conf.sample-stream | 24 ++++++++++++++++++
pool_config.l | 23 -----------------
9 files changed, 185 insertions(+), 61 deletions(-)
diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html
index c5abe6847..0acd493ea 100644
--- a/doc/pgpool-en.html
+++ b/doc/pgpool-en.html
@@ -518,17 +518,6 @@ comment and will be ignored.</p>
This parameter can only be set at server start.</p>
</dd>
-<dt><a name="PCP_TIMEOUT"></a>pcp_timeout</dt>
- <dd>
- <p>PCP connection's timeout value in seconds. If a client does not
- respond within the set seconds, PCP closes the connection with
- the client. Default is 10 seconds. 0 means no timeout.
- </p>
- <p>
- This can be changed with a reload.</p>
- </dd>
-</dl>
-
<h3>Pools</h3>
<dl>
@@ -3874,6 +3863,9 @@ All following options are required to be specified in watchdog process.
<p>
If on, activates watchdog. Default is off.
</p>
+ <p>
+ You need to restart pgpool-II if you change this value.
+ </p>
</dd>
</dl>
@@ -3887,6 +3879,9 @@ All following options are required to be specified in watchdog process.
Each server is required to respond to ping.
Specify a comma separated list of servers such as "hostA,hostB,hostC".
</p>
+ <p>
+ You need to restart pgpool-II if you change this value.
+ </p>
</dd>
<dt><a name="PING_PATH"></a>ping_path <span class="version">V3.2 -</span></dt>
@@ -3896,6 +3891,9 @@ All following options are required to be specified in watchdog process.
to the upper servers.
Set the only path such as "/bin".
</p>
+ <p>
+ You need to restart pgpool-II if you change this value.
+ </p>
</dd>
</dl>
@@ -3909,6 +3907,9 @@ All following options are required to be specified in watchdog process.
in second.
(A number greater than or equal to 1)
</p>
+ <p>
+ You need to restart pgpool-II if you change this value.
+ </p>
</dd>
<dt><a name="WD_LIFE_POINT"></a>wd_life_point <span class="version">V3.2 -</span></dt>
@@ -3917,6 +3918,9 @@ All following options are required to be specified in watchdog process.
The times to retry a failed life check of pgpool-II.
(A number greater than or equal to 1)
</p>
+ <p>
+ You need to restart pgpool-II if you change this value.
+ </p>
</dd>
<dt><a name="WD_LIFECHECK_QUERY"></a>wd_lifecheck_query <span class="version">V3.2 -</span></dt>
@@ -3925,6 +3929,9 @@ All following options are required to be specified in watchdog process.
Actual query to check pgpool-II.
Default is "SELECT 1"
</p>
+ <p>
+ You need to restart pgpool-II if you change this value.
+ </p>
</dd>
<dt><a name="WD_LIFECHECK_DBNAME"></a>wd_lifecheck_dbname <span class="version">V3.3 -</span></dt>
@@ -3963,6 +3970,9 @@ All following options are required to be specified in watchdog process.
client servers (application servers etc.).
When a pgpool is switched from standby to active, the pgpool takes over this VIP.
</p>
+ <p>
+ You need to restart pgpool-II if you change this value.
+ </p>
</dd>
<dt><a name="IFCONFIG_PATH"></a>ifconfig_path <span class="version">V3.2 -</span></dt>
@@ -3971,6 +3981,9 @@ All following options are required to be specified in watchdog process.
This parameter specifies a path of a command to switch the IP address.
Set the only path such as "/sbin".
</p>
+ <p>
+ You need to restart pgpool-II if you change this value.
+ </p>
</dd>
<dt><a name="IF_UP_CMD"></a>if_up_cmd <span class="version">V3.2 -</span></dt>
@@ -3981,6 +3994,9 @@ All following options are required to be specified in watchdog process.
"ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0".
$_IP_$ is replaced by the IP address specified in <a href="#DELEGATE_IP">delegate_IP</a>.
</p>
+ <p>
+ You need to restart pgpool-II if you change this value.
+ </p>
</dd>
<dt><a name="IF_DOWN_CMD"></a>if_down_cmd <span class="version">V3.2 -</span></dt>
@@ -3990,6 +4006,9 @@ All following options are required to be specified in watchdog process.
Set the command and parameters such as
"ifconfig eth0:0 down".
</p>
+ <p>
+ You need to restart pgpool-II if you change this value.
+ </p>
</dd>
<dt><a name="ARPING_PATH"></a>arping_path <span class="version">V3.2 -</span></dt>
@@ -3999,6 +4018,9 @@ All following options are required to be specified in watchdog process.
after the virtual IP is switched.
Set the only path such as "/usr/sbin".
</p>
+ <p>
+ You need to restart pgpool-II if you change this value.
+ </p>
</dd>
<dt><a name="ARPING_CMD"></a>arping_cmd <span class="version">V3.2 -</span></dt>
@@ -4010,6 +4032,9 @@ All following options are required to be specified in watchdog process.
"arping -U $_IP_$ -w 1".
$_IP_$ is replaced by the IP address specified in <a href="#DELEGATE_IP">delegate_IP</a>.
</p>
+ <p>
+ You need to restart pgpool-II if you change this value.
+ </p>
</dd>
</dl>
@@ -4020,6 +4045,9 @@ All following options are required to be specified in watchdog process.
<p>
Specifies the hostname or IP address for mutual monitoring of watchdog processes.
</p>
+ <p>
+ You need to restart pgpool-II if you change this value.
+ </p>
</dd>
<dt><a name="WD_PORT"></a>wd_port <span class="version">V3.2 -</span></dt>
@@ -4027,6 +4055,9 @@ All following options are required to be specified in watchdog process.
<p>
Specifies the port number for mutual monitoring of watchdog processes.
</p>
+ <p>
+ You need to restart pgpool-II if you change this value.
+ </p>
</dd>
</dl>
diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html
index 08897b782..49f52d39e 100644
--- a/doc/pgpool-ja.html
+++ b/doc/pgpool-ja.html
@@ -516,18 +516,6 @@ pgpool.confでは空白行や#で始まる行はコメントと見なされま
</p>
</dd>
-<dt><a name="PCP_TIMEOUT"></a>pcp_timeout</dt>
- <dd>
- <p>
- pcpがpgppoolと接続する際のタイムアウト値。0にするとタイムアウトしません。
- デフォルト値は10(秒)です。
- </p>
- <p>
- このパラメータを変更した時には設定ファイルを再読み込みしてください。
- </p>
- </dd>
-</dl>
-
<h3>Pools</h3>
<dl>
@@ -671,7 +659,7 @@ local0.* /var/log/pgpool.log
trueならばpgpool-IIのログにタイムスタンプを追加します。デフォルトはtrueです。
</p>
<p>
- このパラメータを変更した時には設定ファイルを再読み込みしてください。
+ このパラメータを変更した時には pgpool-II を再起動してください。
</p>
</dd>
@@ -3984,6 +3972,9 @@ watchdog プロセスは以下の項目すべてを指定する必要があり
<p>
watchdog を有効にするには on にします。デフォルトは off です。
</p>
+ <p>
+ このパラメータを変更した時には pgpool-II を再起動してください。
+ </p>
</dd>
</dl>
@@ -4006,6 +3997,9 @@ pgpoolが生きていて PostgreSQLと繋がっている場合でも、
<p>
指定がない場合は上位サーバへのネットワーク到達監視をしません。
</p>
+ <p>
+ このパラメータを変更した時には pgpool-II を再起動してください。
+ </p>
</dd>
<dt><a name="PING_PATH"></a>ping_path <span class="version">V3.2 ～</span></dt>
@@ -4014,6 +4008,9 @@ pgpoolが生きていて PostgreSQLと繋がっている場合でも、
上位サーバへの接続監視に利用する ping コマンドのパスです。
"/bin" のようにパスだけを指定します。
</p>
+ <p>
+ このパラメータを変更した時には pgpool-II を再起動してください。
+ </p>
</dd>
</dl>
@@ -4026,6 +4023,9 @@ pgpoolが生きていて PostgreSQLと繋がっている場合でも、
pgpool-II への生存監視の間隔（秒）です。
（1 以上の数値）
</p>
+ <p>
+ このパラメータを変更した時には pgpool-II を再起動してください。
+ </p>
</dd>
<dt><a name="WD_LIFE_POINT"></a>wd_life_point <span class="version">V3.2 ～</span></dt>
@@ -4034,6 +4034,9 @@ pgpoolが生きていて PostgreSQLと繋がっている場合でも、
pgpool-II の死活監視で応答が得られなかった場合のリトライ回数です。
（1 以上の数値）
</p>
+ <p>
+ このパラメータを変更した時には pgpool-II を再起動してください。
+ </p>
</dd>
<dt><a name="WD_LIFECHECK_QUERY"></a>wd_lifecheck_query <span class="version">V3.2 ～</span></dt>
@@ -4042,6 +4045,9 @@ pgpoolが生きていて PostgreSQLと繋がっている場合でも、
pgpool-II の死活監視のために発行されるクエリです。
デフォルトは "SELECT 1" です。
</p>
+ <p>
+ このパラメータを変更した時には pgpool-II を再起動してください。
+ </p>
</dd>
<dt><a name="WD_LIFECHECK_DBNAME"></a>wd_lifecheck_dbname <span class="version">V3.3 ～</span></dt>
@@ -4078,6 +4084,9 @@ pgpoolが生きていて PostgreSQLと繋がっている場合でも、
（アプリケーションサーバなど）外部からの接続される pgpool-II の仮想 IP アドレスです。
スタンバイからアクティブに切り替わる際、pgpool はこの仮想 IP を引き継ぎます。
</p>
+ <p>
+ このパラメータを変更した時には pgpool-II を再起動してください。
+ </p>
</dd>
<dt><a name="IFCONFIG_PATH"></a>ifconfig_path <span class="version">V3.2 ～</span></dt>
@@ -4086,6 +4095,9 @@ pgpoolが生きていて PostgreSQLと繋がっている場合でも、
IP アドレス切り替えに利用するコマンドのパスです。
"/sbin" のようにパスだけを指定します。
</p>
+ <p>
+ このパラメータを変更した時には pgpool-II を再起動してください。
+ </p>
</dd>
<dt><a name="IF_UP_CMD"></a>if_up_cmd <span class="version">V3.2 ～</span></dt>
@@ -4096,6 +4108,9 @@ pgpoolが生きていて PostgreSQLと繋がっている場合でも、
のようにコマンドとパラメータを指定します。
$_IP_$ は <a href="#DELEGATE_IP">delegate_IP</a> で指定された IP アドレスに置換されます。
</p>
+ <p>
+ このパラメータを変更した時には pgpool-II を再起動してください。
+ </p>
</dd>
<dt><a name="IF_DOWN_CMD"></a>if_down_cmd <span class="version">V3.2 ～</span></dt>
@@ -4105,6 +4120,9 @@ pgpoolが生きていて PostgreSQLと繋がっている場合でも、
"ifconfig eth0:0 down"
のようにコマンドとパラメータを指定します。
</p>
+ <p>
+ このパラメータを変更した時には pgpool-II を再起動してください。
+ </p>
</dd>
<dt><a name="ARPING_PATH"></a>arping_path <span class="version">V3.2 ～</span></dt>
@@ -4113,6 +4131,9 @@ pgpoolが生きていて PostgreSQLと繋がっている場合でも、
IP アドレス切り替え後に ARP リクエストを送信するコマンドのパスです。
"/usr/sbin" のようにパスだけを指定します。
</p>
+ <p>
+ このパラメータを変更した時には pgpool-II を再起動してください。
+ </p>
</dd>
<dt><a name="ARPING_CMD"></a>arping_cmd <span class="version">V3.2 ～</span></dt>
@@ -4123,6 +4144,9 @@ pgpoolが生きていて PostgreSQLと繋がっている場合でも、
のようにコマンドとパラメータを指定します。
$_IP_$ は <a href="#DELEGATE_IP">delegate_IP</a> で指定された IP アドレスに置換されます。
</p>
+ <p>
+ このパラメータを変更した時には pgpool-II を再起動してください。
+ </p>
</dd>
</dl>
@@ -4134,6 +4158,9 @@ pgpoolが生きていて PostgreSQLと繋がっている場合でも、
<p>
watchdog プロセスが相互監視を受信する為のホスト名または IP アドレスです。
</p>
+ <p>
+ このパラメータを変更した時には pgpool-II を再起動してください。
+ </p>
</dd>
<dt><a name="WD_PORT"></a>wd_port <span class="version">V3.2 ～</span></dt>
@@ -4141,6 +4168,9 @@ pgpoolが生きていて PostgreSQLと繋がっている場合でも、
<p>
watchdog プロセスが相互監視を受信する為のポート番号です。
</p>
+ <p>
+ このパラメータを変更した時には pgpool-II を再起動してください。
+ </p>
</dd>
</dl>
diff --git a/doc/tutorial-memqcache-en.html b/doc/tutorial-memqcache-en.html
index 7be1032c2..0c9ce60aa 100644
--- a/doc/tutorial-memqcache-en.html
+++ b/doc/tutorial-memqcache-en.html
@@ -154,9 +154,7 @@ Pgpool discards all the cache of that table automatically by default.</p>
memqcache_auto_cache_invalidation = on
</pre>
-<p>Reload pgpool after changing the parameter's value.</p>
-<pre>$ {installed_dir}/bin/pgpool reload
-</pre>
+<p>Restart pgpool after changing the parameter's value.</p>
<h4 id="invalidation_try">Trying the cache invalidation</h4>
<p>Confirm that you can get the result of a SELECT from cache.</p>
@@ -185,9 +183,7 @@ Default is 0 seconds, but set 5 seconds to confirm for trial this time.</p>
memqcache_expire = 5
</pre>
-<p>Reload pgpool after changing the parameter's value.</p>
-<pre>$ {installed_dir}/bin/pgpool reload
-</pre>
+<p>Restart pgpool after changing the parameter's value.</p>
<h4 id="expire_try">Try</h4>
diff --git a/doc/tutorial-memqcache-ja.html b/doc/tutorial-memqcache-ja.html
index b14e64d72..292de346d 100644
--- a/doc/tutorial-memqcache-ja.html
+++ b/doc/tutorial-memqcache-ja.html
@@ -177,10 +177,7 @@ LOG: <b>query result fetched from cache.</b> statement: SELECT * FROM table_ca
memqcache_auto_cache_invalidation = on
</pre>
-<p>設定を変更した場合は、pgpool-II をリロードします。</p>
-<pre>
-$ {installed_dir}/bin/pgpool reload
-</pre>
+<p>設定を変更した場合は、pgpool-II を再起動します。</p>
<h4 id="invalidation_try">動作確認</h4>
<p>SELECT がキャッシュされていることを確認します。</p>
@@ -213,10 +210,7 @@ LOG: DB node id: 0 backend pid: 11203 statement: SELECT * FROM table_cache_ok
memqcache_expire = 5
</pre>
-<p>設定を変更したら、pgpool-II をリロードします。</p>
-<pre>
-$ {installed_dir}/bin/pgpool reload
-</pre>
+<p>設定を変更したら、pgpool-II を再起動します。</p>
<h4 id="expire_try">動作確認</h4>
diff --git a/pgpool.conf.sample b/pgpool.conf.sample
index 2d53f7639..fd238bc0d 100644
--- a/pgpool.conf.sample
+++ b/pgpool.conf.sample
@@ -423,35 +423,49 @@ client_idle_limit_in_recovery = 0
#------------------------------------------------------------------------------
use_watchdog = off
# Activates watchdog
+ # (change requires restart)
trusted_servers = ''
# trusted server list which are used
# to confirm network connection
# (hostA,hostB,hostC,...)
+ # (change requires restart)
delegate_IP = ''
# delegate IP address
+ # (change requires restart)
wd_hostname = ''
# Host name or IP address of this watchdog
+ # (change requires restart)
wd_port = 9000
# port number for watchdog service
+ # (change requires restart)
wd_interval = 10
# lifecheck interval (sec) > 0
+ # (change requires restart)
ping_path = '/bin'
# ping command path
+ # (change requires restart)
ifconfig_path = '/sbin'
# ifconfig command path
+ # (change requires restart)
if_up_cmd = 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0'
# startup delegate IP command
+ # (change requires restart)
if_down_cmd = 'ifconfig eth0:0 down'
# shutdown delegate IP command
+ # (change requires restart)
arping_path = '/usr/sbin' # arping command path
+ # (change requires restart)
arping_cmd = 'arping -U $_IP_$ -w 1'
# arping command
+ # (change requires restart)
wd_life_point = 3
# lifecheck retry times
+ # (change requires restart)
wd_lifecheck_query = 'SELECT 1'
# lifecheck query to pgpool from watchdog
+ # (change requires restart)
wd_lifecheck_dbname = 'template1'
# Database name connected for lifecheck
wd_lifecheck_user = 'nobody'
@@ -513,37 +527,47 @@ memory_cache_enabled = off
memqcache_method = 'shmem'
# Cache storage method. either 'shmem'(shared memory) or
# 'memcached'. 'shmem' by default
+ # (change requires restart)
memqcache_memcached_host = 'localhost'
# Memcached host name or IP address. Mandatory if
# memqcache_method = 'memcached'.
# Defaults to localhost.
+ # (change requires restart)
memqcache_memcached_port = 11211
# Memcached port number. Mondatory if memqcache_method = 'memcached'.
# Defaults to 11211.
+ # (change requires restart)
memqcache_total_size = 67108864
# Total memory size in bytes for storing memory cache.
# Mandatory if memqcache_method = 'shmem'.
# Defaults to 64MB.
+ # (change requires restart)
memqcache_max_num_cache = 1000000
# Total number of cache entries. Mandatory
# if memqcache_method = 'shmem'.
# Each cache entry consumes 48 bytes on shared memory.
# Defaults to 1,000,000(45.8MB).
+ # (change requires restart)
memqcache_expire = 0
# Memory cache entry life time specified in seconds.
# 0 means infinite life time. 0 by default.
+ # (change requires restart)
memqcache_auto_cache_invalidation = on
# If on, invalidation of query cache is triggered by corresponding
# DDL/DML/DCL(and memqcache_expire). If off, it is only triggered
# by memqcache_expire. on by default.
+ # (change requires restart)
memqcache_maxcache = 409600
# Maximum SELECT result size in bytes.
# Must be smaller than memqcache_cache_block_size. Defaults to 400KB.
+ # (change requires restart)
memqcache_cache_block_size = 1048576
# Cache block size in bytes. Mandatory if memqcache_method = 'shmem'.
# Defaults to 1MB.
+ # (change requires restart)
memqcache_oiddir = '/var/log/pgpool/oiddir'
# Temporary work directory to record table oids
+ # (change requires restart)
white_memqcache_table_list = ''
# Comma separated list of table names to memcache
# that don't write to database
diff --git a/pgpool.conf.sample-master-slave b/pgpool.conf.sample-master-slave
index 1730cafd5..0096a0450 100644
--- a/pgpool.conf.sample-master-slave
+++ b/pgpool.conf.sample-master-slave
@@ -423,35 +423,49 @@ client_idle_limit_in_recovery = 0
#------------------------------------------------------------------------------
use_watchdog = off
# Activates watchdog
+ # (change requires restart)
trusted_servers = ''
# trusted server list which are used
# to confirm network connection
# (hostA,hostB,hostC,...)
+ # (change requires restart)
delegate_IP = ''
# delegate IP address
+ # (change requires restart)
wd_hostname = ''
# Host name or IP address of this watchdog
+ # (change requires restart)
wd_port = 9000
# port number for watchdog service
+ # (change requires restart)
wd_interval = 10
# lifecheck interval (sec) > 0
+ # (change requires restart)
ping_path = '/bin'
# ping command path
+ # (change requires restart)
ifconfig_path = '/sbin'
# ifconfig command path
+ # (change requires restart)
if_up_cmd = 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0'
# startup delegate IP command
+ # (change requires restart)
if_down_cmd = 'ifconfig eth0:0 down'
# shutdown delegate IP command
+ # (change requires restart)
arping_path = '/usr/sbin' # arping command path
+ # (change requires restart)
arping_cmd = 'arping -U $_IP_$ -w 1'
# arping command
+ # (change requires restart)
wd_life_point = 3
# lifecheck retry times
+ # (change requires restart)
wd_lifecheck_query = 'SELECT 1'
# lifecheck query to pgpool from watchdog
+ # (change requires restart)
wd_lifecheck_dbname = 'template1'
# Database name connected for lifecheck
wd_lifecheck_user = 'nobody'
@@ -512,37 +526,47 @@ memory_cache_enabled = off
memqcache_method = 'shmem'
# Cache storage method. either 'shmem'(shared memory) or
# 'memcached'. 'shmem' by default
+ # (change requires restart)
memqcache_memcached_host = 'localhost'
# Memcached host name or IP address. Mandatory if
# memqcache_method = 'memcached'.
# Defaults to localhost.
+ # (change requires restart)
memqcache_memcached_port = 11211
# Memcached port number. Mondatory if memqcache_method = 'memcached'.
# Defaults to 11211.
+ # (change requires restart)
memqcache_total_size = 67108864
# Total memory size in bytes for storing memory cache.
# Mandatory if memqcache_method = 'shmem'.
# Defaults to 64MB.
+ # (change requires restart)
memqcache_max_num_cache = 1000000
# Total number of cache entries. Mandatory
# if memqcache_method = 'shmem'.
# Each cache entry consumes 48 bytes on shared memory.
# Defaults to 1,000,000(45.8MB).
+ # (change requires restart)
memqcache_expire = 0
# Memory cache entry life time specified in seconds.
# 0 means infinite life time. 0 by default.
+ # (change requires restart)
memqcache_auto_cache_invalidation = on
# If on, invalidation of query cache is triggered by corresponding
# DDL/DML/DCL(and memqcache_expire). If off, it is only triggered
# by memqcache_expire. on by default.
+ # (change requires restart)
memqcache_maxcache = 409600
# Maximum SELECT result size in bytes.
# Must be smaller than memqcache_cache_block_size. Defaults to 400KB.
+ # (change requires restart)
memqcache_cache_block_size = 1048576
# Cache block size in bytes. Mandatory if memqcache_method = 'shmem'.
# Defaults to 1MB.
+ # (change requires restart)
memqcache_oiddir = '/var/log/pgpool/oiddir'
# Temporary work directory to record table oids
+ # (change requires restart)
white_memqcache_table_list = ''
# Comma separated list of table names to memcache
# that don't write to database
diff --git a/pgpool.conf.sample-replication b/pgpool.conf.sample-replication
index c5bc5ba9e..5b3639165 100644
--- a/pgpool.conf.sample-replication
+++ b/pgpool.conf.sample-replication
@@ -422,35 +422,49 @@ client_idle_limit_in_recovery = 0
#------------------------------------------------------------------------------
use_watchdog = off
# Activates watchdog
+ # (change requires restart)
trusted_servers = ''
# trusted server list which are used
# to confirm network connection
# (hostA,hostB,hostC,...)
+ # (change requires restart)
delegate_IP = ''
# delegate IP address
+ # (change requires restart)
wd_hostname = ''
# Host name or IP address of this watchdog
+ # (change requires restart)
wd_port = 9000
# port number for watchdog service
+ # (change requires restart)
wd_interval = 10
# lifecheck interval (sec) > 0
+ # (change requires restart)
ping_path = '/bin'
# ping command path
+ # (change requires restart)
ifconfig_path = '/sbin'
# ifconfig command path
+ # (change requires restart)
if_up_cmd = 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0'
# startup delegate IP command
+ # (change requires restart)
if_down_cmd = 'ifconfig eth0:0 down'
# shutdown delegate IP command
+ # (change requires restart)
arping_path = '/usr/sbin' # arping command path
+ # (change requires restart)
arping_cmd = 'arping -U $_IP_$ -w 1'
# arping command
+ # (change requires restart)
wd_life_point = 3
# lifecheck retry times
+ # (change requires restart)
wd_lifecheck_query = 'SELECT 1'
# lifecheck query to pgpool from watchdog
+ # (change requires restart)
wd_lifecheck_dbname = 'template1'
# Database name connected for lifecheck
wd_lifecheck_user = 'nobody'
@@ -511,37 +525,47 @@ memory_cache_enabled = off
memqcache_method = 'shmem'
# Cache storage method. either 'shmem'(shared memory) or
# 'memcached'. 'shmem' by default
+ # (change requires restart)
memqcache_memcached_host = 'localhost'
# Memcached host name or IP address. Mandatory if
# memqcache_method = 'memcached'.
# Defaults to localhost.
+ # (change requires restart)
memqcache_memcached_port = 11211
# Memcached port number. Mondatory if memqcache_method = 'memcached'.
# Defaults to 11211.
+ # (change requires restart)
memqcache_total_size = 67108864
# Total memory size in bytes for storing memory cache.
# Mandatory if memqcache_method = 'shmem'.
# Defaults to 64MB.
+ # (change requires restart)
memqcache_max_num_cache = 1000000
# Total number of cache entries. Mandatory
# if memqcache_method = 'shmem'.
# Each cache entry consumes 48 bytes on shared memory.
# Defaults to 1,000,000(45.8MB).
+ # (change requires restart)
memqcache_expire = 0
# Memory cache entry life time specified in seconds.
# 0 means infinite life time. 0 by default.
+ # (change requires restart)
memqcache_auto_cache_invalidation = on
# If on, invalidation of query cache is triggered by corresponding
# DDL/DML/DCL(and memqcache_expire). If off, it is only triggered
# by memqcache_expire. on by default.
+ # (change requires restart)
memqcache_maxcache = 409600
# Maximum SELECT result size in bytes.
# Must be smaller than memqcache_cache_block_size. Defaults to 400KB.
+ # (change requires restart)
memqcache_cache_block_size = 1048576
# Cache block size in bytes. Mandatory if memqcache_method = 'shmem'.
# Defaults to 1MB.
+ # (change requires restart)
memqcache_oiddir = '/var/log/pgpool/oiddir'
# Temporary work directory to record table oids
+ # (change requires restart)
white_memqcache_table_list = ''
# Comma separated list of table names to memcache
# that don't write to database
diff --git a/pgpool.conf.sample-stream b/pgpool.conf.sample-stream
index 71ea695cf..8bb28e349 100644
--- a/pgpool.conf.sample-stream
+++ b/pgpool.conf.sample-stream
@@ -422,35 +422,49 @@ client_idle_limit_in_recovery = 0
#------------------------------------------------------------------------------
use_watchdog = off
# Activates watchdog
+ # (change requires restart)
trusted_servers = ''
# trusted server list which are used
# to confirm network connection
# (hostA,hostB,hostC,...)
+ # (change requires restart)
delegate_IP = ''
# delegate IP address
+ # (change requires restart)
wd_hostname = ''
# Host name or IP address of this watchdog
+ # (change requires restart)
wd_port = 9000
# port number for watchdog service
+ # (change requires restart)
wd_interval = 10
# lifecheck interval (sec) > 0
+ # (change requires restart)
ping_path = '/bin'
# ping command path
+ # (change requires restart)
ifconfig_path = '/sbin'
# ifconfig command path
+ # (change requires restart)
if_up_cmd = 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0'
# startup delegate IP command
+ # (change requires restart)
if_down_cmd = 'ifconfig eth0:0 down'
# shutdown delegate IP command
+ # (change requires restart)
arping_path = '/usr/sbin' # arping command path
+ # (change requires restart)
arping_cmd = 'arping -U $_IP_$ -w 1'
# arping command
+ # (change requires restart)
wd_life_point = 3
# lifecheck retry times
+ # (change requires restart)
wd_lifecheck_query = 'SELECT 1'
# lifecheck query to pgpool from watchdog
+ # (change requires restart)
wd_lifecheck_dbname = 'template1'
# Database name connected for lifecheck
wd_lifecheck_user = 'nobody'
@@ -511,37 +525,47 @@ memory_cache_enabled = off
memqcache_method = 'shmem'
# Cache storage method. either 'shmem'(shared memory) or
# 'memcached'. 'shmem' by default
+ # (change requires restart)
memqcache_memcached_host = 'localhost'
# Memcached host name or IP address. Mandatory if
# memqcache_method = 'memcached'.
# Defaults to localhost.
+ # (change requires restart)
memqcache_memcached_port = 11211
# Memcached port number. Mondatory if memqcache_method = 'memcached'.
# Defaults to 11211.
+ # (change requires restart)
memqcache_total_size = 67108864
# Total memory size in bytes for storing memory cache.
# Mandatory if memqcache_method = 'shmem'.
# Defaults to 64MB.
+ # (change requires restart)
memqcache_max_num_cache = 1000000
# Total number of cache entries. Mandatory
# if memqcache_method = 'shmem'.
# Each cache entry consumes 48 bytes on shared memory.
# Defaults to 1,000,000(45.8MB).
+ # (change requires restart)
memqcache_expire = 0
# Memory cache entry life time specified in seconds.
# 0 means infinite life time. 0 by default.
+ # (change requires restart)
memqcache_auto_cache_invalidation = on
# If on, invalidation of query cache is triggered by corresponding
# DDL/DML/DCL(and memqcache_expire). If off, it is only triggered
# by memqcache_expire. on by default.
+ # (change requires restart)
memqcache_maxcache = 409600
# Maximum SELECT result size in bytes.
# Must be smaller than memqcache_cache_block_size. Defaults to 400KB.
+ # (change requires restart)
memqcache_cache_block_size = 1048576
# Cache block size in bytes. Mandatory if memqcache_method = 'shmem'.
# Defaults to 1MB.
+ # (change requires restart)
memqcache_oiddir = '/var/log/pgpool/oiddir'
# Temporary work directory to record table oids
+ # (change requires restart)
white_memqcache_table_list = ''
# Comma separated list of table names to memcache
# that don't write to database
diff --git a/pool_config.l b/pool_config.l
index a93fa12e1..4cb4cae4a 100644
--- a/pool_config.l
+++ b/pool_config.l
@@ -1853,17 +1853,6 @@ int pool_get_config(char *confpath, POOL_CONFIG_CONTEXT context)
}
pool_config->log_per_node_statement = v;
}
- else if (!strcmp(key, "log_statement") && CHECK_CONTEXT(INIT_CONFIG|RELOAD_CONFIG, context))
- {
- int v = eval_logical(yytext);
-
- if (v < 0)
- {
- pool_error("pool_config: invalid value %s for %s", yytext, key);
- return(-1);
- }
- pool_config->log_statement = v;
- }
else if (!strcmp(key, "lobj_lock_table") && CHECK_CONTEXT(INIT_CONFIG|RELOAD_CONFIG, context))
{
@@ -2475,18 +2464,6 @@ int pool_get_config(char *confpath, POOL_CONFIG_CONTEXT context)
}
pool_config->memqcache_total_size = v;
}
- else if (!strcmp(key, "memqcache_total_size") && CHECK_CONTEXT(INIT_CONFIG, context))
- {
- int v = atoi(yytext);
-
- if (token != POOL_INTEGER || v < 0)
- {
- pool_error("pool_config: %s must be equal or higher than 0 numeric value", key);
- fclose(fd);
- return(-1);
- }
- pool_config->memqcache_total_size = v;
- }
else if (!strcmp(key, "memqcache_max_num_cache") && CHECK_CONTEXT(INIT_CONFIG, context))
{
int v = atoi(yytext);
[parent: 6173bf38934a]