pgpool2.git / summary / log / commit / refs

commit    ec083d82deb2b4621315a593c976cc41ae3dfb2f
Author:   Tatsuo Ishii <ishii@sraoss.co.jp>
Date:     Tue May 02 00:38:44 2023 +0000

    Test: unbreak 033.prefer_lower_standby_delay.
    
    Commit "7a28bbb1 Fix 033.prefer_lower_standby_delay" broke
    033.prefer_lower_standby_delay for PostgreSQL 13 or before because
    they do not have pg_get_wal_replay_pause_state().


 .../tests/033.prefer_lower_standby_delay/test.sh           | 14 ++++++++++----
 1 file changed, 10 insertions(+), 4 deletions(-)

diff --git a/src/test/regression/tests/033.prefer_lower_standby_delay/test.sh b/src/test/regression/tests/033.prefer_lower_standby_delay/test.sh
index 6a64c318c..af7c37146 100755
--- a/src/test/regression/tests/033.prefer_lower_standby_delay/test.sh
+++ b/src/test/regression/tests/033.prefer_lower_standby_delay/test.sh
@@ -10,17 +10,23 @@ PSQL="$PGBIN/psql -X "
 version=`$PSQL --version|awk '{print $3}'`
 major_version=`echo ${version%.*} | sed 's/\([0-9]*\).*/\1/'`
 
-result=`echo "$major_version >= 10"|bc`
-if [ $result == 1 ];then
+if [ $major_version -ge 10 ];then
 	REPLAY_PAUSE="SELECT pg_wal_replay_pause();"
 	REPLAY_RESUME="SELECT pg_wal_replay_resume();"
-	REPLAY_STATE="SELECT pg_get_wal_replay_pause_state()"
 else
 	REPLAY_PAUSE="SELECT pg_xlog_replay_pause();"
 	REPLAY_RESUME="SELECT pg_xlog_replay_resume();"
-	REPLAY_STATE="SELECT pg_get_xlog_replay_pause_state()"
 fi
 
+# PostgreSQL 13 or before does not have pg_get_wal_replay_pause_state().
+# In these versions SELECT pg_wal_replay_pause() immediately pauses.
+if [ $major_version -ge 14 ];then
+	REPLAY_STATE="SELECT pg_get_wal_replay_pause_state()"
+else
+	REPLAY_STATE="SELECT 'paused'"
+fi
+
+
 # node 1 port number
 PORT1=11003
 


[parent: c7f9be67e28c]