From 5a25a29849c7f7c757bf9c51e74418534c9a94eb Mon Sep 17 00:00:00 2001 From: Bo Peng Date: Mon, 26 Feb 2024 19:43:10 +0900 Subject: [PATCH] Fix the default values. Fixed the default values of the following parameters: - recovery_user - failover_on_backend_shutdown - insert_lock --- src/config/pool_config_variables.c | 4 ++-- src/sample/pgpool.conf.sample-stream | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/src/config/pool_config_variables.c b/src/config/pool_config_variables.c index a6405b031..a9f0862da 100644 --- a/src/config/pool_config_variables.c +++ b/src/config/pool_config_variables.c @@ -579,7 +579,7 @@ static struct config_bool ConfigureNamesBool[] = CONFIG_VAR_TYPE_BOOL, false, 0 }, &g_pool_config.failover_on_backend_shutdown, - true, + false, NULL, NULL, NULL }, @@ -982,7 +982,7 @@ static struct config_string ConfigureNamesString[] = CONFIG_VAR_TYPE_STRING, false, 0 }, &g_pool_config.recovery_user, - "", + "nobody", NULL, NULL, NULL, NULL }, diff --git a/src/sample/pgpool.conf.sample-stream b/src/sample/pgpool.conf.sample-stream index b238e5712..8b326fd13 100644 --- a/src/sample/pgpool.conf.sample-stream +++ b/src/sample/pgpool.conf.sample-stream @@ -373,7 +373,7 @@ backend_clustering_mode = 'streaming_replication' # replicate_select is higher priority than # load_balance_mode. -#insert_lock = off +#insert_lock = on # Automatically locks a dummy row or a table # with INSERT statements to keep SERIAL data # consistency @@ -626,7 +626,7 @@ backend_clustering_mode = 'streaming_replication' #failover_on_backend_shutdown = off # Initiates failover when backend is shutdown, - # or backend process is killed. + # or backend process is killed. # If set to off, pgpool will report an # error and disconnect the session. -- 2.39.5