pgpool2.git / summary / log / commit / refs
commit 3f9834cc1b7a6d17ee9cb2cf67cf4db8b5dd6083
Author: Bo Peng <pengbo@sraoss.co.jp>
Date: Thu Mar 07 01:27:31 2019 +0000
Fix indent of pgpool.conf sample files.
src/sample/pgpool.conf.sample | 169 +++++++++++++-------------
src/sample/pgpool.conf.sample-logical | 178 +++++++++++++--------------
src/sample/pgpool.conf.sample-master-slave | 187 +++++++++++++++--------------
src/sample/pgpool.conf.sample-replication | 181 ++++++++++++++--------------
src/sample/pgpool.conf.sample-stream | 177 +++++++++++++--------------
5 files changed, 448 insertions(+), 444 deletions(-)
diff --git a/src/sample/pgpool.conf.sample b/src/sample/pgpool.conf.sample
index 20e734377..998920db4 100644
--- a/src/sample/pgpool.conf.sample
+++ b/src/sample/pgpool.conf.sample
@@ -38,7 +38,7 @@ socket_dir = '/tmp'
# (change requires restart)
listen_backlog_multiplier = 2
# Set the backlog parameter of listen(2) to
- # num_init_children * listen_backlog_multiplier.
+ # num_init_children * listen_backlog_multiplier.
# (change requires restart)
serialize_accept = off
# whether to serialize accept() call to avoid thundering herd problem
@@ -96,9 +96,9 @@ authentication_timeout = 60
# 0 means no timeout.
allow_clear_text_frontend_auth = off
- # Allow Pgpool-II to use clear text password authentication
- # with clients, when pool_passwd does not
- # contain the user password
+ # Allow Pgpool-II to use clear text password authentication
+ # with clients, when pool_passwd does not
+ # contain the user password
# - SSL Connections -
@@ -312,34 +312,35 @@ black_query_pattern_list = ''
# Semicolon separated list of query patterns
# that should be sent to primary node
# Regexp are accepted
- # valid for streaming replicaton mode only.
+ # valid for streaming replicaton mode only.
database_redirect_preference_list = ''
- # comma separated list of pairs of database and node id.
- # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'
- # valid for streaming replicaton mode only.
+ # comma separated list of pairs of database and node id.
+ # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'
+ # valid for streaming replicaton mode only.
app_name_redirect_preference_list = ''
- # comma separated list of pairs of app name and node id.
- # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'
- # valid for streaming replicaton mode only.
+ # comma separated list of pairs of app name and node id.
+ # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'
+ # valid for streaming replicaton mode only.
allow_sql_comments = off
- # if on, ignore SQL comments when judging if load balance or
- # query cache is possible.
- # If off, SQL comments effectively prevent the judgment
- # (pre 3.4 behavior).
-
-disable_load_balance_on_write = 'transaction' # Load balance behavior when write query is issued
- # in an explicit transaction.
- # Note that any query not in an explicit transaction
- # is not affected by the parameter.
- # 'transaction' (the default): if a write query is issued,
- # subsequent read queries will not be load balanced
- # until the transaction ends.
- # 'trans_transaction': if a write query is issued,
- # subsequent read queries in an explicit transaction
- # will not be load balanced until the session ends.
- # 'always': if a write query is issued, read queries will
- # not be load balanced until the session ends.
+ # if on, ignore SQL comments when judging if load balance or
+ # query cache is possible.
+ # If off, SQL comments effectively prevent the judgment
+ # (pre 3.4 behavior).
+
+disable_load_balance_on_write = 'transaction'
+ # Load balance behavior when write query is issued
+ # in an explicit transaction.
+ # Note that any query not in an explicit transaction
+ # is not affected by the parameter.
+ # 'transaction' (the default): if a write query is issued,
+ # subsequent read queries will not be load balanced
+ # until the transaction ends.
+ # 'trans_transaction': if a write query is issued,
+ # subsequent read queries in an explicit transaction
+ # will not be load balanced until the session ends.
+ # 'always': if a write query is issued, read queries will
+ # not be load balanced until the session ends.
#------------------------------------------------------------------------------
# MASTER/SLAVE MODE
@@ -366,9 +367,9 @@ sr_check_user = 'nobody'
# sr_check_period = 0
sr_check_password = ''
- # Password for streaming replication check user.
- # Leaving it empty will make Pgpool-II to first look for the
- # Password in pool_passwd file before using the empty password
+ # Password for streaming replication check user.
+ # Leaving it empty will make Pgpool-II to first look for the
+ # Password in pool_passwd file before using the empty password
sr_check_database = 'postgres'
# Database name for streaming replication check
@@ -420,10 +421,10 @@ health_check_retry_delay = 1
# Amount of time to wait (in seconds) between retries.
connect_timeout = 10000
# Timeout value in milliseconds before giving up to connect to backend.
- # Default is 10000 ms (10 second). Flaky network user may want to increase
- # the value. 0 means no timeout.
- # Note that this value is not only used for health check,
- # but also for ordinary conection to backend.
+ # Default is 10000 ms (10 second). Flaky network user may want to increase
+ # the value. 0 means no timeout.
+ # Note that this value is not only used for health check,
+ # but also for ordinary conection to backend.
#------------------------------------------------------------------------------
# HEALTH CHECK PER NODE PARAMETERS (OPTIONAL)
@@ -545,18 +546,18 @@ wd_port = 9000
# port number for watchdog service
# (change requires restart)
wd_priority = 1
- # priority of this watchdog in leader election
- # (change requires restart)
+ # priority of this watchdog in leader election
+ # (change requires restart)
wd_authkey = ''
# Authentication key for watchdog communication
# (change requires restart)
wd_ipc_socket_dir = '/tmp'
- # Unix domain socket path for watchdog IPC socket
- # The Debian package defaults to
- # /var/run/postgresql
- # (change requires restart)
+ # Unix domain socket path for watchdog IPC socket
+ # The Debian package defaults to
+ # /var/run/postgresql
+ # (change requires restart)
# - Virtual IP control Setting -
@@ -594,36 +595,36 @@ wd_escalation_command = ''
# Executes this command at escalation on new active pgpool.
# (change requires restart)
wd_de_escalation_command = ''
- # Executes this command when master pgpool resigns from being master.
- # (change requires restart)
+ # Executes this command when master pgpool resigns from being master.
+ # (change requires restart)
# - Watchdog consensus settings for failover -
failover_when_quorum_exists = on
- # Only perform backend node failover
- # when the watchdog cluster holds the quorum
- # (change requires restart)
+ # Only perform backend node failover
+ # when the watchdog cluster holds the quorum
+ # (change requires restart)
failover_require_consensus = on
- # Perform failover when majority of Pgpool-II nodes
- # aggrees on the backend node status change
- # (change requires restart)
+ # Perform failover when majority of Pgpool-II nodes
+ # aggrees on the backend node status change
+ # (change requires restart)
allow_multiple_failover_requests_from_node = off
- # A Pgpool-II node can cast multiple votes
- # for building the consensus on failover
- # (change requires restart)
+ # A Pgpool-II node can cast multiple votes
+ # for building the consensus on failover
+ # (change requires restart)
# - Lifecheck Setting -
# -- common --
wd_monitoring_interfaces_list = '' # Comma separated list of interfaces names to monitor.
- # if any interface from the list is active the watchdog will
- # consider the network is fine
- # 'any' to enable monitoring on all interfaces except loopback
- # '' to disable monitoring
- # (change requires restart)
+ # if any interface from the list is active the watchdog will
+ # consider the network is fine
+ # 'any' to enable monitoring on all interfaces except loopback
+ # '' to disable monitoring
+ # (change requires restart)
wd_lifecheck_method = 'heartbeat'
@@ -681,8 +682,8 @@ wd_lifecheck_user = 'nobody'
# (change requires restart)
wd_lifecheck_password = ''
# Password for watchdog user in lifecheck
- # Leaving it empty will make Pgpool-II to first look for the
- # Password in pool_passwd file before using the empty password
+ # Leaving it empty will make Pgpool-II to first look for the
+ # Password in pool_passwd file before using the empty password
# (change requires restart)
# - Other pgpool Connection Settings -
@@ -751,51 +752,51 @@ enable_shared_relcache = off
# IN MEMORY QUERY MEMORY CACHE
#------------------------------------------------------------------------------
memory_cache_enabled = off
- # If on, use the memory cache functionality, off by default
+ # If on, use the memory cache functionality, off by default
# (change requires restart)
memqcache_method = 'shmem'
- # Cache storage method. either 'shmem'(shared memory) or
- # 'memcached'. 'shmem' by default
+ # 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.
+ # 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.
+ # 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.
+ # 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).
+ # 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.
+ # 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.
+ # 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.
+ # 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.
+ # 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
+ # Temporary work directory to record table oids
# (change requires restart)
white_memqcache_table_list = ''
# Comma separated list of table names to memcache
diff --git a/src/sample/pgpool.conf.sample-logical b/src/sample/pgpool.conf.sample-logical
index fde99245b..b75c1ed5d 100644
--- a/src/sample/pgpool.conf.sample-logical
+++ b/src/sample/pgpool.conf.sample-logical
@@ -58,7 +58,7 @@ pcp_socket_dir = '/tmp'
# (change requires restart)
listen_backlog_multiplier = 2
# Set the backlog parameter of listen(2) to
- # num_init_children * listen_backlog_multiplier.
+ # num_init_children * listen_backlog_multiplier.
# (change requires restart)
serialize_accept = off
# whether to serialize accept() call to avoid thundering herd problem
@@ -77,7 +77,7 @@ backend_data_directory0 = '/data'
backend_flag0 = 'ALLOW_TO_FAILOVER'
# Controls various backend behavior
# ALLOW_TO_FAILOVER, DISALLOW_TO_FAILOVER
- # or ALWAYS_MASTER
+ # or ALWAYS_MASTER
#backend_hostname1 = 'host2'
#backend_port1 = 5433
#backend_weight1 = 1
@@ -315,19 +315,19 @@ black_query_pattern_list = ''
# valid for streaming replicaton mode only.
database_redirect_preference_list = ''
- # comma separated list of pairs of database and node id.
- # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'
- # valid for streaming replicaton mode only.
+ # comma separated list of pairs of database and node id.
+ # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'
+ # valid for streaming replicaton mode only.
app_name_redirect_preference_list = ''
- # comma separated list of pairs of app name and node id.
- # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'
- # valid for streaming replicaton mode only.
+ # comma separated list of pairs of app name and node id.
+ # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'
+ # valid for streaming replicaton mode only.
allow_sql_comments = off
- # if on, ignore SQL comments when judging if load balance or
- # query cache is possible.
- # If off, SQL comments effectively prevent the judgment
- # (pre 3.4 behavior).
+ # if on, ignore SQL comments when judging if load balance or
+ # query cache is possible.
+ # If off, SQL comments effectively prevent the judgment
+ # (pre 3.4 behavior).
#------------------------------------------------------------------------------
# MASTER/SLAVE MODE
@@ -338,7 +338,7 @@ master_slave_mode = on
# (change requires restart)
master_slave_sub_mode = 'logical'
# Master/slave sub mode
- # Valid values are combinations stream, slony
+ # Valid values are combinations stream, slony
# or logical. Default is stream.
# (change requires restart)
@@ -376,8 +376,8 @@ follow_master_command = ''
# %H = hostname of the new master node
# %M = old master node id
# %P = old primary node id
- # %r = new master port number
- # %R = new master database cluster path
+ # %r = new master port number
+ # %R = new master database cluster path
# %% = '%' character
#------------------------------------------------------------------------------
@@ -405,10 +405,10 @@ health_check_retry_delay = 1
# Amount of time to wait (in seconds) between retries.
connect_timeout = 10000
# Timeout value in milliseconds before giving up to connect to backend.
- # Default is 10000 ms (10 second). Flaky network user may want to increase
- # the value. 0 means no timeout.
- # Note that this value is not only used for health check,
- # but also for ordinary conection to backend.
+ # Default is 10000 ms (10 second). Flaky network user may want to increase
+ # the value. 0 means no timeout.
+ # Note that this value is not only used for health check,
+ # but also for ordinary conection to backend.
#------------------------------------------------------------------------------
# HEALTH CHECK PER NODE PARAMETERS (OPTIONAL)
@@ -437,8 +437,8 @@ failover_command = ''
# %H = hostname of the new master node
# %M = old master node id
# %P = old primary node id
- # %r = new master port number
- # %R = new master database cluster path
+ # %r = new master port number
+ # %R = new master database cluster path
# %% = '%' character
failback_command = ''
# Executes this command at failback.
@@ -451,8 +451,8 @@ failback_command = ''
# %H = hostname of the new master node
# %M = old master node id
# %P = old primary node id
- # %r = new master port number
- # %R = new master database cluster path
+ # %r = new master port number
+ # %R = new master database cluster path
# %% = '%' character
failover_on_backend_error = on
@@ -530,18 +530,18 @@ wd_port = 9000
# port number for watchdog service
# (change requires restart)
wd_priority = 1
- # priority of this watchdog in leader election
- # (change requires restart)
+ # priority of this watchdog in leader election
+ # (change requires restart)
wd_authkey = ''
# Authentication key for watchdog communication
# (change requires restart)
wd_ipc_socket_dir = '/tmp'
- # Unix domain socket path for watchdog IPC socket
- # The Debian package defaults to
- # /var/run/postgresql
- # (change requires restart)
+ # Unix domain socket path for watchdog IPC socket
+ # The Debian package defaults to
+ # /var/run/postgresql
+ # (change requires restart)
# - Virtual IP control Setting -
@@ -579,31 +579,31 @@ wd_escalation_command = ''
# Executes this command at escalation on new active pgpool.
# (change requires restart)
wd_de_escalation_command = ''
- # Executes this command when master pgpool resigns from being master.
- # (change requires restart)
+ # Executes this command when master pgpool resigns from being master.
+ # (change requires restart)
# - Watchdog consensus settings for failover -
failover_when_quorum_exists = on
- # Only perform backend node failover
- # when the watchdog cluster holds the quorum
+ # Only perform backend node failover
+ # when the watchdog cluster holds the quorum
failover_require_consensus = on
- # Perform failover when majority of Pgpool-II nodes
- # aggrees on the backend node status change
+ # Perform failover when majority of Pgpool-II nodes
+ # aggrees on the backend node status change
enable_multiple_failover_requests_from_node = off
- # A Pgpool-II node can cast multiple votes
- # for building the consensus on failover
+ # A Pgpool-II node can cast multiple votes
+ # for building the consensus on failover
# - Lifecheck Setting -
# -- common --
wd_monitoring_interfaces_list = '' # Comma separated list of interfaces names to monitor.
- # if any interface from the list is active the watchdog will
- # consider the network is fine
- # 'any' to enable monitoring on all interfaces except loopback
- # '' to disable monitoring
+ # if any interface from the list is active the watchdog will
+ # consider the network is fine
+ # 'any' to enable monitoring on all interfaces except loopback
+ # '' to disable monitoring
wd_lifecheck_method = 'heartbeat'
# Method of watchdog lifecheck ('heartbeat' or 'query' or 'external')
@@ -701,16 +701,16 @@ relcache_expire = 0
relcache_size = 256
# Number of relation cache
# entry. If you see frequently:
- # "pool_search_relcache: cache replacement happend"
- # in the pgpool log, you might want to increate this number.
+ # "pool_search_relcache: cache replacement happend"
+ # in the pgpool log, you might want to increate this number.
check_temp_table = on
# If on, enable temporary table check in SELECT statements.
# This initiates queries against system catalog of primary/master
- # thus increases load of master.
- # If you are absolutely sure that your system never uses temporary tables
- # and you want to save access to primary/master, you could turn this off.
- # Default is on.
+ # thus increases load of master.
+ # If you are absolutely sure that your system never uses temporary tables
+ # and you want to save access to primary/master, you could turn this off.
+ # Default is on.
check_unlogged_table = on
# If on, enable unlogged table check in SELECT statements.
@@ -729,57 +729,57 @@ enable_shared_relcache = off
# IN MEMORY QUERY MEMORY CACHE
#------------------------------------------------------------------------------
memory_cache_enabled = off
- # If on, use the memory cache functionality, off by default
- # (change requires restart)
+ # If on, use the memory cache functionality, off by default
+ # (change requires restart)
memqcache_method = 'shmem'
- # Cache storage method. either 'shmem'(shared memory) or
- # 'memcached'. 'shmem' by default
- # (change requires restart)
+ # 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)
+ # 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)
+ # 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)
+ # 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)
+ # 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)
+ # 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)
+ # 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)
+ # 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)
+ # 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)
+ # 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
- # Regexp are accepted
+ # Comma separated list of table names to memcache
+ # that don't write to database
+ # Regexp are accepted
black_memqcache_table_list = ''
- # Comma separated list of table names not to memcache
- # that don't write to database
- # Regexp are accepted
+ # Comma separated list of table names not to memcache
+ # that don't write to database
+ # Regexp are accepted
diff --git a/src/sample/pgpool.conf.sample-master-slave b/src/sample/pgpool.conf.sample-master-slave
index 5603a1117..24c5b8415 100644
--- a/src/sample/pgpool.conf.sample-master-slave
+++ b/src/sample/pgpool.conf.sample-master-slave
@@ -38,7 +38,7 @@ socket_dir = '/tmp'
# (change requires restart)
listen_backlog_multiplier = 2
# Set the backlog parameter of listen(2) to
- # num_init_children * listen_backlog_multiplier.
+ # num_init_children * listen_backlog_multiplier.
# (change requires restart)
serialize_accept = off
# whether to serialize accept() call to avoid thundering herd problem
@@ -76,7 +76,7 @@ backend_data_directory0 = '/data'
backend_flag0 = 'ALLOW_TO_FAILOVER'
# Controls various backend behavior
# ALLOW_TO_FAILOVER, DISALLOW_TO_FAILOVER
- # or ALWAYS_MASTER
+ # or ALWAYS_MASTER
#backend_hostname1 = 'host2'
#backend_port1 = 5433
#backend_weight1 = 1
@@ -96,9 +96,9 @@ authentication_timeout = 60
# 0 means no timeout.
allow_clear_text_frontend_auth = off
- # Allow Pgpool-II to use clear text password authentication
- # with clients, when pool_passwd does not
- # contain the user password
+ # Allow Pgpool-II to use clear text password authentication
+ # with clients, when pool_passwd does not
+ # contain the user password
# - SSL Connections -
@@ -314,32 +314,33 @@ black_query_pattern_list = ''
# valid for streaming replicaton mode only.
database_redirect_preference_list = ''
- # comma separated list of pairs of database and node id.
- # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'
- # valid for streaming replicaton mode only.
+ # comma separated list of pairs of database and node id.
+ # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'
+ # valid for streaming replicaton mode only.
app_name_redirect_preference_list = ''
- # comma separated list of pairs of app name and node id.
- # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'
- # valid for streaming replicaton mode only.
+ # comma separated list of pairs of app name and node id.
+ # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'
+ # valid for streaming replicaton mode only.
allow_sql_comments = off
- # if on, ignore SQL comments when judging if load balance or
- # query cache is possible.
- # If off, SQL comments effectively prevent the judgment
- # (pre 3.4 behavior).
-
-disable_load_balance_on_write = 'transaction' # Load balance behavior when write query is issued
- # in an explicit transaction.
- # Note that any query not in an explicit transaction
- # is not affected by the parameter.
- # 'transaction' (the default): if a write query is issued,
- # subsequent read queries will not be load balanced
- # until the transaction ends.
- # 'trans_transaction': if a write query is issued,
- # subsequent read queries in an explicit transaction
- # will not be load balanced until the session ends.
- # 'always': if a write query is issued, read queries will
- # not be load balanced until the session ends.
+ # if on, ignore SQL comments when judging if load balance or
+ # query cache is possible.
+ # If off, SQL comments effectively prevent the judgment
+ # (pre 3.4 behavior).
+
+disable_load_balance_on_write = 'transaction'
+ # Load balance behavior when write query is issued
+ # in an explicit transaction.
+ # Note that any query not in an explicit transaction
+ # is not affected by the parameter.
+ # 'transaction' (the default): if a write query is issued,
+ # subsequent read queries will not be load balanced
+ # until the transaction ends.
+ # 'trans_transaction': if a write query is issued,
+ # subsequent read queries in an explicit transaction
+ # will not be load balanced until the session ends.
+ # 'always': if a write query is issued, read queries will
+ # not be load balanced until the session ends.
#------------------------------------------------------------------------------
# MASTER/SLAVE MODE
@@ -389,8 +390,8 @@ follow_master_command = ''
# %H = hostname of the new master node
# %M = old master node id
# %P = old primary node id
- # %r = new master port number
- # %R = new master database cluster path
+ # %r = new master port number
+ # %R = new master database cluster path
# %% = '%' character
#------------------------------------------------------------------------------
@@ -418,10 +419,10 @@ health_check_retry_delay = 1
# Amount of time to wait (in seconds) between retries.
connect_timeout = 10000
# Timeout value in milliseconds before giving up to connect to backend.
- # Default is 10000 ms (10 second). Flaky network user may want to increase
- # the value. 0 means no timeout.
- # Note that this value is not only used for health check,
- # but also for ordinary conection to backend.
+ # Default is 10000 ms (10 second). Flaky network user may want to increase
+ # the value. 0 means no timeout.
+ # Note that this value is not only used for health check,
+ # but also for ordinary conection to backend.
#------------------------------------------------------------------------------
# HEALTH CHECK PER NODE PARAMETERS (OPTIONAL)
@@ -450,8 +451,8 @@ failover_command = ''
# %H = hostname of the new master node
# %M = old master node id
# %P = old primary node id
- # %r = new master port number
- # %R = new master database cluster path
+ # %r = new master port number
+ # %R = new master database cluster path
# %% = '%' character
failback_command = ''
@@ -465,8 +466,8 @@ failback_command = ''
# %H = hostname of the new master node
# %M = old master node id
# %P = old primary node id
- # %r = new master port number
- # %R = new master database cluster path
+ # %r = new master port number
+ # %R = new master database cluster path
# %% = '%' character
failover_on_backend_error = on
@@ -544,18 +545,18 @@ wd_port = 9000
# port number for watchdog service
# (change requires restart)
wd_priority = 1
- # priority of this watchdog in leader election
- # (change requires restart)
+ # priority of this watchdog in leader election
+ # (change requires restart)
wd_authkey = ''
# Authentication key for watchdog communication
# (change requires restart)
wd_ipc_socket_dir = '/tmp'
- # Unix domain socket path for watchdog IPC socket
- # The Debian package defaults to
- # /var/run/postgresql
- # (change requires restart)
+ # Unix domain socket path for watchdog IPC socket
+ # The Debian package defaults to
+ # /var/run/postgresql
+ # (change requires restart)
# - Virtual IP control Setting -
@@ -592,26 +593,26 @@ wd_escalation_command = ''
# Executes this command at escalation on new active pgpool.
# (change requires restart)
wd_de_escalation_command = ''
- # Executes this command when master pgpool resigns from being master.
- # (change requires restart)
+ # Executes this command when master pgpool resigns from being master.
+ # (change requires restart)
# - Watchdog consensus settings for failover -
failover_when_quorum_exists = on
- # Only perform backend node failover
- # when the watchdog cluster holds the quorum
- # (change requires restart)
+ # Only perform backend node failover
+ # when the watchdog cluster holds the quorum
+ # (change requires restart)
failover_require_consensus = on
- # Perform failover when majority of Pgpool-II nodes
- # aggrees on the backend node status change
- # (change requires restart)
+ # Perform failover when majority of Pgpool-II nodes
+ # aggrees on the backend node status change
+ # (change requires restart)
allow_multiple_failover_requests_from_node = off
- # A Pgpool-II node can cast multiple votes
- # for building the consensus on failover
- # (change requires restart)
+ # A Pgpool-II node can cast multiple votes
+ # for building the consensus on failover
+ # (change requires restart)
# - Lifecheck Setting -
@@ -619,11 +620,11 @@ allow_multiple_failover_requests_from_node = off
# -- common --
wd_monitoring_interfaces_list = '' # Comma separated list of interfaces names to monitor.
- # if any interface from the list is active the watchdog will
- # consider the network is fine
- # 'any' to enable monitoring on all interfaces except loopback
- # '' to disable monitoring
- # (change requires restart)
+ # if any interface from the list is active the watchdog will
+ # consider the network is fine
+ # 'any' to enable monitoring on all interfaces except loopback
+ # '' to disable monitoring
+ # (change requires restart)
wd_lifecheck_method = 'heartbeat'
# Method of watchdog lifecheck ('heartbeat' or 'query' or 'external')
@@ -680,8 +681,8 @@ wd_lifecheck_user = 'nobody'
# (change requires restart)
wd_lifecheck_password = ''
# Password for watchdog user in lifecheck
- # Leaving it empty will make Pgpool-II to first look for the
- # Password in pool_passwd file before using the empty password
+ # Leaving it empty will make Pgpool-II to first look for the
+ # Password in pool_passwd file before using the empty password
# (change requires restart)
# - Other pgpool Connection Settings -
@@ -721,16 +722,16 @@ relcache_expire = 0
relcache_size = 256
# Number of relation cache
# entry. If you see frequently:
- # "pool_search_relcache: cache replacement happend"
- # in the pgpool log, you might want to increate this number.
+ # "pool_search_relcache: cache replacement happend"
+ # in the pgpool log, you might want to increate this number.
check_temp_table = on
# If on, enable temporary table check in SELECT statements.
# This initiates queries against system catalog of primary/master
- # thus increases load of master.
- # If you are absolutely sure that your system never uses temporary tables
- # and you want to save access to primary/master, you could turn this off.
- # Default is on.
+ # thus increases load of master.
+ # If you are absolutely sure that your system never uses temporary tables
+ # and you want to save access to primary/master, you could turn this off.
+ # Default is on.
check_unlogged_table = on
# If on, enable unlogged table check in SELECT statements.
@@ -749,51 +750,51 @@ enable_shared_relcache = off
# IN MEMORY QUERY MEMORY CACHE
#------------------------------------------------------------------------------
memory_cache_enabled = off
- # If on, use the memory cache functionality, off by default
+ # If on, use the memory cache functionality, off by default
# (change requires restart)
memqcache_method = 'shmem'
- # Cache storage method. either 'shmem'(shared memory) or
- # 'memcached'. 'shmem' by default
+ # 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.
+ # 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.
+ # 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.
+ # 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).
+ # 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.
+ # 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.
+ # 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.
+ # 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.
+ # 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
+ # Temporary work directory to record table oids
# (change requires restart)
white_memqcache_table_list = ''
# Comma separated list of table names to memcache
diff --git a/src/sample/pgpool.conf.sample-replication b/src/sample/pgpool.conf.sample-replication
index 2544a834e..067fd4b03 100644
--- a/src/sample/pgpool.conf.sample-replication
+++ b/src/sample/pgpool.conf.sample-replication
@@ -38,7 +38,7 @@ socket_dir = '/tmp'
# (change requires restart)
listen_backlog_multiplier = 2
# Set the backlog parameter of listen(2) to
- # num_init_children * listen_backlog_multiplier.
+ # num_init_children * listen_backlog_multiplier.
# (change requires restart)
serialize_accept = off
# whether to serialize accept() call to avoid thundering herd problem
@@ -310,35 +310,36 @@ black_query_pattern_list = ''
# Semicolon separated list of query patterns
# that should be sent to primary node
# Regexp are accepted
- # valid for streaming replicaton mode only.
+ # valid for streaming replicaton mode only.
database_redirect_preference_list = ''
- # comma separated list of pairs of database and node id.
- # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'
- # valid for streaming replicaton mode only.
+ # comma separated list of pairs of database and node id.
+ # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'
+ # valid for streaming replicaton mode only.
app_name_redirect_preference_list = ''
- # comma separated list of pairs of app name and node id.
- # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'
- # valid for streaming replicaton mode only.
+ # comma separated list of pairs of app name and node id.
+ # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'
+ # valid for streaming replicaton mode only.
allow_sql_comments = off
- # if on, ignore SQL comments when judging if load balance or
- # query cache is possible.
- # If off, SQL comments effectively prevent the judgment
- # (pre 3.4 behavior).
-
-disable_load_balance_on_write = 'transaction' # Load balance behavior when write query is issued
- # in an explicit transaction.
- # Note that any query not in an explicit transaction
- # is not affected by the parameter.
- # 'transaction' (the default): if a write query is issued,
- # subsequent read queries will not be load balanced
- # until the transaction ends.
- # 'trans_transaction': if a write query is issued,
- # subsequent read queries in an explicit transaction
- # will not be load balanced until the session ends.
- # 'always': if a write query is issued, read queries will
- # not be load balanced until the session ends.
+ # if on, ignore SQL comments when judging if load balance or
+ # query cache is possible.
+ # If off, SQL comments effectively prevent the judgment
+ # (pre 3.4 behavior).
+
+disable_load_balance_on_write = 'transaction'
+ # Load balance behavior when write query is issued
+ # in an explicit transaction.
+ # Note that any query not in an explicit transaction
+ # is not affected by the parameter.
+ # 'transaction' (the default): if a write query is issued,
+ # subsequent read queries will not be load balanced
+ # until the transaction ends.
+ # 'trans_transaction': if a write query is issued,
+ # subsequent read queries in an explicit transaction
+ # will not be load balanced until the session ends.
+ # 'always': if a write query is issued, read queries will
+ # not be load balanced until the session ends.
#------------------------------------------------------------------------------
# MASTER/SLAVE MODE
@@ -388,8 +389,8 @@ follow_master_command = ''
# %H = hostname of the new master node
# %M = old master node id
# %P = old primary node id
- # %r = new master port number
- # %R = new master database cluster path
+ # %r = new master port number
+ # %R = new master database cluster path
# %% = '%' character
#------------------------------------------------------------------------------
@@ -417,10 +418,10 @@ health_check_retry_delay = 1
# Amount of time to wait (in seconds) between retries.
connect_timeout = 10000
# Timeout value in milliseconds before giving up to connect to backend.
- # Default is 10000 ms (10 second). Flaky network user may want to increase
- # the value. 0 means no timeout.
- # Note that this value is not only used for health check,
- # but also for ordinary conection to backend.
+ # Default is 10000 ms (10 second). Flaky network user may want to increase
+ # the value. 0 means no timeout.
+ # Note that this value is not only used for health check,
+ # but also for ordinary conection to backend.
#------------------------------------------------------------------------------
# HEALTH CHECK PER NODE PARAMETERS (OPTIONAL)
@@ -449,8 +450,8 @@ failover_command = ''
# %H = hostname of the new master node
# %M = old master node id
# %P = old primary node id
- # %r = new master port number
- # %R = new master database cluster path
+ # %r = new master port number
+ # %R = new master database cluster path
# %% = '%' character
failback_command = ''
# Executes this command at failback.
@@ -463,8 +464,8 @@ failback_command = ''
# %H = hostname of the new master node
# %M = old master node id
# %P = old primary node id
- # %r = new master port number
- # %R = new master database cluster path
+ # %r = new master port number
+ # %R = new master database cluster path
# %% = '%' character
failover_on_backend_error = on
@@ -543,18 +544,18 @@ wd_port = 9000
# (change requires restart)
wd_priority = 1
- # priority of this watchdog in leader election
- # (change requires restart)
+ # priority of this watchdog in leader election
+ # (change requires restart)
wd_authkey = ''
# Authentication key for watchdog communication
# (change requires restart)
wd_ipc_socket_dir = '/tmp'
- # Unix domain socket path for watchdog IPC socket
- # The Debian package defaults to
- # /var/run/postgresql
- # (change requires restart)
+ # Unix domain socket path for watchdog IPC socket
+ # The Debian package defaults to
+ # /var/run/postgresql
+ # (change requires restart)
# - Virtual IP control Setting -
@@ -592,25 +593,25 @@ wd_escalation_command = ''
# Executes this command at escalation on new active pgpool.
# (change requires restart)
wd_de_escalation_command = ''
- # Executes this command when master pgpool resigns from being master.
- # (change requires restart)
+ # Executes this command when master pgpool resigns from being master.
+ # (change requires restart)
# - Watchdog consensus settings for failover -
failover_when_quorum_exists = on
- # Only perform backend node failover
- # when the watchdog cluster holds the quorum
- # (change requires restart)
+ # Only perform backend node failover
+ # when the watchdog cluster holds the quorum
+ # (change requires restart)
failover_require_consensus = on
- # Perform failover when majority of Pgpool-II nodes
- # aggrees on the backend node status change
- # (change requires restart)
+ # Perform failover when majority of Pgpool-II nodes
+ # aggrees on the backend node status change
+ # (change requires restart)
allow_multiple_failover_requests_from_node = off
- # A Pgpool-II node can cast multiple votes
- # for building the consensus on failover
- # (change requires restart)
+ # A Pgpool-II node can cast multiple votes
+ # for building the consensus on failover
+ # (change requires restart)
# - Lifecheck Setting -
@@ -618,11 +619,11 @@ allow_multiple_failover_requests_from_node = off
# -- common --
wd_monitoring_interfaces_list = '' # Comma separated list of interfaces names to monitor.
- # if any interface from the list is active the watchdog will
- # consider the network is fine
- # 'any' to enable monitoring on all interfaces except loopback
- # '' to disable monitoring
- # (change requires restart)
+ # if any interface from the list is active the watchdog will
+ # consider the network is fine
+ # 'any' to enable monitoring on all interfaces except loopback
+ # '' to disable monitoring
+ # (change requires restart)
wd_lifecheck_method = 'heartbeat'
# Method of watchdog lifecheck ('heartbeat' or 'query' or 'external')
@@ -679,8 +680,8 @@ wd_lifecheck_user = 'nobody'
# (change requires restart)
wd_lifecheck_password = ''
# Password for watchdog user in lifecheck
- # Leaving it empty will make Pgpool-II to first look for the
- # Password in pool_passwd file before using the empty password
+ # Leaving it empty will make Pgpool-II to first look for the
+ # Password in pool_passwd file before using the empty password
# (change requires restart)
# - Other pgpool Connection Settings -
@@ -720,16 +721,16 @@ relcache_expire = 0
relcache_size = 256
# Number of relation cache
# entry. If you see frequently:
- # "pool_search_relcache: cache replacement happend"
- # in the pgpool log, you might want to increate this number.
+ # "pool_search_relcache: cache replacement happend"
+ # in the pgpool log, you might want to increate this number.
check_temp_table = on
# If on, enable temporary table check in SELECT statements.
# This initiates queries against system catalog of primary/master
- # thus increases load of master.
- # If you are absolutely sure that your system never uses temporary tables
- # and you want to save access to primary/master, you could turn this off.
- # Default is on.
+ # thus increases load of master.
+ # If you are absolutely sure that your system never uses temporary tables
+ # and you want to save access to primary/master, you could turn this off.
+ # Default is on.
check_unlogged_table = on
# If on, enable unlogged table check in SELECT statements.
@@ -748,51 +749,51 @@ enable_shared_relcache = off
# IN MEMORY QUERY MEMORY CACHE
#------------------------------------------------------------------------------
memory_cache_enabled = off
- # If on, use the memory cache functionality, off by default
+ # If on, use the memory cache functionality, off by default
# (change requires restart)
memqcache_method = 'shmem'
- # Cache storage method. either 'shmem'(shared memory) or
- # 'memcached'. 'shmem' by default
+ # 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.
+ # 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.
+ # 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.
+ # 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).
+ # 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.
+ # 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.
+ # 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.
+ # 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.
+ # 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
+ # Temporary work directory to record table oids
# (change requires restart)
white_memqcache_table_list = ''
# Comma separated list of table names to memcache
diff --git a/src/sample/pgpool.conf.sample-stream b/src/sample/pgpool.conf.sample-stream
index f0c760c26..ecb196734 100644
--- a/src/sample/pgpool.conf.sample-stream
+++ b/src/sample/pgpool.conf.sample-stream
@@ -58,7 +58,7 @@ pcp_socket_dir = '/tmp'
# (change requires restart)
listen_backlog_multiplier = 2
# Set the backlog parameter of listen(2) to
- # num_init_children * listen_backlog_multiplier.
+ # num_init_children * listen_backlog_multiplier.
# (change requires restart)
serialize_accept = off
# whether to serialize accept() call to avoid thundering herd problem
@@ -77,7 +77,7 @@ backend_data_directory0 = '/data'
backend_flag0 = 'ALLOW_TO_FAILOVER'
# Controls various backend behavior
# ALLOW_TO_FAILOVER, DISALLOW_TO_FAILOVER
- # or ALWAYS_MASTER
+ # or ALWAYS_MASTER
#backend_hostname1 = 'host2'
#backend_port1 = 5433
#backend_weight1 = 1
@@ -315,32 +315,33 @@ black_query_pattern_list = ''
# valid for streaming replicaton mode only.
database_redirect_preference_list = ''
- # comma separated list of pairs of database and node id.
- # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'
- # valid for streaming replicaton mode only.
+ # comma separated list of pairs of database and node id.
+ # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'
+ # valid for streaming replicaton mode only.
app_name_redirect_preference_list = ''
- # comma separated list of pairs of app name and node id.
- # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'
- # valid for streaming replicaton mode only.
+ # comma separated list of pairs of app name and node id.
+ # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'
+ # valid for streaming replicaton mode only.
allow_sql_comments = off
- # if on, ignore SQL comments when judging if load balance or
- # query cache is possible.
- # If off, SQL comments effectively prevent the judgment
- # (pre 3.4 behavior).
-
-disable_load_balance_on_write = 'transaction' # Load balance behavior when write query is issued
- # in an explicit transaction.
- # Note that any query not in an explicit transaction
- # is not affected by the parameter.
- # 'transaction' (the default): if a write query is issued,
- # subsequent read queries will not be load balanced
- # until the transaction ends.
- # 'trans_transaction': if a write query is issued,
- # subsequent read queries in an explicit transaction
- # will not be load balanced until the session ends.
- # 'always': if a write query is issued, read queries will
- # not be load balanced until the session ends.
+ # if on, ignore SQL comments when judging if load balance or
+ # query cache is possible.
+ # If off, SQL comments effectively prevent the judgment
+ # (pre 3.4 behavior).
+
+disable_load_balance_on_write = 'transaction'
+ # Load balance behavior when write query is issued
+ # in an explicit transaction.
+ # Note that any query not in an explicit transaction
+ # is not affected by the parameter.
+ # 'transaction' (the default): if a write query is issued,
+ # subsequent read queries will not be load balanced
+ # until the transaction ends.
+ # 'trans_transaction': if a write query is issued,
+ # subsequent read queries in an explicit transaction
+ # will not be load balanced until the session ends.
+ # 'always': if a write query is issued, read queries will
+ # not be load balanced until the session ends.
#------------------------------------------------------------------------------
# MASTER/SLAVE MODE
@@ -389,8 +390,8 @@ follow_master_command = ''
# %H = hostname of the new master node
# %M = old master node id
# %P = old primary node id
- # %r = new master port number
- # %R = new master database cluster path
+ # %r = new master port number
+ # %R = new master database cluster path
# %% = '%' character
#------------------------------------------------------------------------------
@@ -418,10 +419,10 @@ health_check_retry_delay = 1
# Amount of time to wait (in seconds) between retries.
connect_timeout = 10000
# Timeout value in milliseconds before giving up to connect to backend.
- # Default is 10000 ms (10 second). Flaky network user may want to increase
- # the value. 0 means no timeout.
- # Note that this value is not only used for health check,
- # but also for ordinary conection to backend.
+ # Default is 10000 ms (10 second). Flaky network user may want to increase
+ # the value. 0 means no timeout.
+ # Note that this value is not only used for health check,
+ # but also for ordinary conection to backend.
#------------------------------------------------------------------------------
# HEALTH CHECK PER NODE PARAMETERS (OPTIONAL)
@@ -450,8 +451,8 @@ failover_command = ''
# %H = hostname of the new master node
# %M = old master node id
# %P = old primary node id
- # %r = new master port number
- # %R = new master database cluster path
+ # %r = new master port number
+ # %R = new master database cluster path
# %% = '%' character
failback_command = ''
# Executes this command at failback.
@@ -464,8 +465,8 @@ failback_command = ''
# %H = hostname of the new master node
# %M = old master node id
# %P = old primary node id
- # %r = new master port number
- # %R = new master database cluster path
+ # %r = new master port number
+ # %R = new master database cluster path
# %% = '%' character
failover_on_backend_error = on
@@ -543,18 +544,18 @@ wd_port = 9000
# port number for watchdog service
# (change requires restart)
wd_priority = 1
- # priority of this watchdog in leader election
- # (change requires restart)
+ # priority of this watchdog in leader election
+ # (change requires restart)
wd_authkey = ''
# Authentication key for watchdog communication
# (change requires restart)
wd_ipc_socket_dir = '/tmp'
- # Unix domain socket path for watchdog IPC socket
- # The Debian package defaults to
- # /var/run/postgresql
- # (change requires restart)
+ # Unix domain socket path for watchdog IPC socket
+ # The Debian package defaults to
+ # /var/run/postgresql
+ # (change requires restart)
# - Virtual IP control Setting -
@@ -592,25 +593,25 @@ wd_escalation_command = ''
# Executes this command at escalation on new active pgpool.
# (change requires restart)
wd_de_escalation_command = ''
- # Executes this command when master pgpool resigns from being master.
- # (change requires restart)
+ # Executes this command when master pgpool resigns from being master.
+ # (change requires restart)
# - Watchdog consensus settings for failover -
failover_when_quorum_exists = on
- # Only perform backend node failover
- # when the watchdog cluster holds the quorum
- # (change requires restart)
+ # Only perform backend node failover
+ # when the watchdog cluster holds the quorum
+ # (change requires restart)
failover_require_consensus = on
- # Perform failover when majority of Pgpool-II nodes
- # aggrees on the backend node status change
- # (change requires restart)
+ # Perform failover when majority of Pgpool-II nodes
+ # aggrees on the backend node status change
+ # (change requires restart)
allow_multiple_failover_requests_from_node = off
- # A Pgpool-II node can cast multiple votes
- # for building the consensus on failover
- # (change requires restart)
+ # A Pgpool-II node can cast multiple votes
+ # for building the consensus on failover
+ # (change requires restart)
# - Lifecheck Setting -
@@ -618,11 +619,11 @@ allow_multiple_failover_requests_from_node = off
# -- common --
wd_monitoring_interfaces_list = '' # Comma separated list of interfaces names to monitor.
- # if any interface from the list is active the watchdog will
- # consider the network is fine
- # 'any' to enable monitoring on all interfaces except loopback
- # '' to disable monitoring
- # (change requires restart)
+ # if any interface from the list is active the watchdog will
+ # consider the network is fine
+ # 'any' to enable monitoring on all interfaces except loopback
+ # '' to disable monitoring
+ # (change requires restart)
wd_lifecheck_method = 'heartbeat'
# Method of watchdog lifecheck ('heartbeat' or 'query' or 'external')
@@ -720,16 +721,16 @@ relcache_expire = 0
relcache_size = 256
# Number of relation cache
# entry. If you see frequently:
- # "pool_search_relcache: cache replacement happend"
- # in the pgpool log, you might want to increate this number.
+ # "pool_search_relcache: cache replacement happend"
+ # in the pgpool log, you might want to increate this number.
check_temp_table = on
# If on, enable temporary table check in SELECT statements.
# This initiates queries against system catalog of primary/master
- # thus increases load of master.
- # If you are absolutely sure that your system never uses temporary tables
- # and you want to save access to primary/master, you could turn this off.
- # Default is on.
+ # thus increases load of master.
+ # If you are absolutely sure that your system never uses temporary tables
+ # and you want to save access to primary/master, you could turn this off.
+ # Default is on.
check_unlogged_table = on
# If on, enable unlogged table check in SELECT statements.
@@ -748,51 +749,51 @@ enable_shared_relcache = off
# IN MEMORY QUERY MEMORY CACHE
#------------------------------------------------------------------------------
memory_cache_enabled = off
- # If on, use the memory cache functionality, off by default
+ # If on, use the memory cache functionality, off by default
# (change requires restart)
memqcache_method = 'shmem'
- # Cache storage method. either 'shmem'(shared memory) or
- # 'memcached'. 'shmem' by default
+ # 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.
+ # 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.
+ # 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.
+ # 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).
+ # 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.
+ # 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.
+ # 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.
+ # 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.
+ # 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
+ # Temporary work directory to record table oids
# (change requires restart)
white_memqcache_table_list = ''
# Comma separated list of table names to memcache
[parent: 06ad56e6a252]