From b082cd1a057002c8d628c971654925355104a95b Mon Sep 17 00:00:00 2001 From: Bo Peng Date: Mon, 25 Mar 2024 16:10:46 +0900 Subject: [PATCH] Fixed comments in sample pgpool.conf. - The comment for sr_check_period. The default value should be 10 seconds. - Also fixed some typos in comments. Patch is created by hiroin and modified by Bo Peng. --- src/sample/pgpool.conf.sample-stream | 24 ++++++++++++------------ 1 file changed, 12 insertions(+), 12 deletions(-) diff --git a/src/sample/pgpool.conf.sample-stream b/src/sample/pgpool.conf.sample-stream index 0833605ad..fbe7fc827 100644 --- a/src/sample/pgpool.conf.sample-stream +++ b/src/sample/pgpool.conf.sample-stream @@ -54,7 +54,7 @@ backend_clustering_mode = 'streaming_replication' #reserved_connections = 0 # Number of reserved connections. # Pgpool-II does not accept connections if over - # num_init_chidlren - reserved_connections. + # num_init_children - reserved_connections. # - pgpool Communication Manager Connection Settings - @@ -430,22 +430,22 @@ backend_clustering_mode = 'streaming_replication' # 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 replication mode only. #user_redirect_preference_list = '' # comma separated list of pairs of user name and node id. # example: postgres:primary,user[0-4]:1,user[5-9]:2' - # valid for streaming replicaton mode only. + # valid for streaming replication 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. + # valid for streaming replication 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. + # valid for streaming replication mode only. #allow_sql_comments = off # if on, ignore SQL comments when judging if load balance or # query cache is possible. @@ -502,10 +502,10 @@ backend_clustering_mode = 'streaming_replication' #sr_check_period = 10 # Streaming replication check period - # Disabled (0) by default + # Default is 10s. #sr_check_user = 'nobody' # Streaming replication check user - # This is neccessary even if you disable streaming + # This is necessary even if you disable streaming # replication delay check by sr_check_period = 0 #sr_check_password = '' # Password for streaming replication check user @@ -576,7 +576,7 @@ backend_clustering_mode = 'streaming_replication' # 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. + # but also for ordinary connection to backend. #------------------------------------------------------------------------------ # HEALTH CHECK PER NODE PARAMETERS (OPTIONAL) @@ -641,7 +641,7 @@ backend_clustering_mode = 'streaming_replication' #detach_false_primary = off # Detach false primary if on. Only - # valid in streaming replicaton + # valid in streaming replication # mode and with PostgreSQL 9.6 or # after. @@ -678,7 +678,7 @@ backend_clustering_mode = 'streaming_replication' # -1 means immediate disconnection #auto_failback = off - # Dettached backend node reattach automatically + # Detached backend node reattach automatically # if replicatiotate is 'streaming'. #auto_failback_interval = 1min # Min interval of executing auto_failback in @@ -703,7 +703,7 @@ backend_clustering_mode = 'streaming_replication' # (change requires restart) #trusted_server_command = 'ping -q -c3 %h' - # Command to excute when communicate trusted server. + # Command to execute when communicate trusted server. # Special values: # %h = host name specified by trusted_servers @@ -930,7 +930,7 @@ backend_clustering_mode = 'streaming_replication' #relcache_size = 256 # Number of relation cache # entry. If you see frequently: - # "pool_search_relcache: cache replacement happend" + # "pool_search_relcache: cache replacement happened" # in the pgpool log, you might want to increate this number. #check_temp_table = catalog -- 2.39.5