From 3f9834cc1b7a6d17ee9cb2cf67cf4db8b5dd6083 Mon Sep 17 00:00:00 2001 From: Bo Peng Date: Thu, 7 Mar 2019 10:27:31 +0900 Subject: [PATCH] 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 -- 2.39.5