From 3f9a0a3d2ecea2ffd36282c7b7d5060bc1aacafb Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Wed, 1 Jul 2020 11:33:04 +0900 Subject: [PATCH] Let pgpool_setup set REPEATABLE READ while creating snapshot isolation mode. 030.snapshot_isolation/test.sh does not need the work anymore. --- src/test/pgpool_setup | 5 +++++ src/test/regression/tests/030.snapshot_isolation/test.sh | 4 ---- 2 files changed, 5 insertions(+), 4 deletions(-) diff --git a/src/test/pgpool_setup b/src/test/pgpool_setup index a074b8647..089279a65 100755 --- a/src/test/pgpool_setup +++ b/src/test/pgpool_setup @@ -347,6 +347,11 @@ function set_postgresql_conf fi fi + # Snapshot isolation mode requires REPEATABLE READ transaction isolation mode. + if [ $MODE = 'i' ];then + echo "default_transaction_isolation = 'repeatable read'" >> $PGCONF + fi + sed -i '/host.*all.*all.*trust$/s/^/#/g' $PGHBACONF sed -i '/local.*all.*all.*trust$/s/^/#/g' $PGHBACONF diff --git a/src/test/regression/tests/030.snapshot_isolation/test.sh b/src/test/regression/tests/030.snapshot_isolation/test.sh index ea24f40bd..e3d1388bc 100755 --- a/src/test/regression/tests/030.snapshot_isolation/test.sh +++ b/src/test/regression/tests/030.snapshot_isolation/test.sh @@ -20,10 +20,6 @@ echo "done." dir=`pwd` -# SI mode requires REPEATABLE READ transaction isolation mode. -echo "default_transaction_isolation = 'repeatable read'" >> data0/postgresql.conf -echo "default_transaction_isolation = 'repeatable read'" >> data1/postgresql.conf - source ./bashrc.ports ./startall -- 2.39.5