From 22cc8ef69a071a698437a45bbd8336922a639d6c Mon Sep 17 00:00:00 2001
From: Bo Peng <pengbo@sraoss.co.jp>
Date: Thu, 17 May 2018 09:12:59 +0900
Subject: [PATCH] Improve failover.sh of pgpool_setup to avoid test error.

---
 src/test/pgpool_setup | 12 ++++++++++++
 1 file changed, 12 insertions(+)

diff --git a/src/test/pgpool_setup b/src/test/pgpool_setup
index b880dab36..e990ccf9f 100755
--- a/src/test/pgpool_setup
+++ b/src/test/pgpool_setup
@@ -154,6 +154,18 @@ if [ a"$failed_node_id" = a"$old_primary_node_id" ];then	# master failed
 ! 	new_primary_db_cluster=${mydir}/data"$new_master_id"
 	echo $pg_ctl -D $new_primary_db_cluster promote >>$log	# let standby take over
 	$pg_ctl -D $new_primary_db_cluster promote >>$log	# let standby take over
+
+	timeout=20
+	while [ $timeout -gt 0 ]
+	do
+		res=`__PGBIN__/psql -At -p $new_master_port_number -c "SELECT pg_is_in_recovery()"`
+		if [[ "$res" = 'f' ]]; then
+			break;
+		fi
+		timeout=`expr $timeout - 1`
+		sleep 1
+	done
+
 fi
 EOF
 
-- 
2.39.5