From 50b4d2780efbaac8f93fc1bc9b45292ff2576cd6 Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Sat, 5 May 2018 07:20:14 +0900 Subject: [PATCH] Fix pgpool_setup to make replication slots properly. It only created pgpool_setup_slot1. It should create pgpool_setup_slot0, pgpool_setup_slot1... pgpool_setup_slotN, where N = number of nodes -1. --- src/test/pgpool_setup | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/test/pgpool_setup b/src/test/pgpool_setup index 1e758b15b..2dba4c1ce 100755 --- a/src/test/pgpool_setup +++ b/src/test/pgpool_setup @@ -74,7 +74,7 @@ LPATH=${PGLIB:-"/usr/local/pgsql/lib"} # unix socket directory PGSOCKET_DIR=${PGSOCKET_DIR:-"/tmp"} # initdb args -INITDBARG="--no-locale -E UTF_8" +INITDBARG="--no-locale -E UTF_8 --data-checksums" # Use replication slot USE_REPLICATION_SLOT=${USE_REPLICATION_SLOT:-"false"} @@ -824,7 +824,7 @@ CREATE EXTENSION pgpool_recovery; CREATE DATABASE test; EOF if [ $USE_SLOT = "true" ];then - n=1 + n=0 while [ $n -lt $NUMCLUSTERS ] do $PSQL -p $BASEPORT template1 -c "SELECT * FROM pg_create_physical_replication_slot('pgpool_setup_slot$n')" >&5 2>&1 -- 2.39.5