pgpool2.git / summary / log / commit / refs

commit    79d16ccdb90ea29eed679dcb7127f0f4bb11dbf0
Author:   Tatsuo Ishii <ishii@postgresql.org>
Date:     Wed Oct 21 11:14:27 2026 +0000

    Test: stabilize 020.allow_clear_text_frontend_auth and 022.pool_passwd_alternative_auth.
    
    These tests use an async streaming replication, which sometimes allows
    pgpool to read stale data from standby and makes the failed because
    the test user is not seen on standby yet.  To fix it, set synchronous
    replication.
    
    Author: Tatsuo Ishii <ishii@postgresql.org>
    Backpatch-through: v4.3


 src/test/regression/tests/020.allow_clear_text_frontend_auth/test.sh | 3 +++
 src/test/regression/tests/022.pool_passwd_alternative_auth/test.sh   | 3 +++
 2 files changed, 6 insertions(+)

diff --git a/src/test/regression/tests/020.allow_clear_text_frontend_auth/test.sh b/src/test/regression/tests/020.allow_clear_text_frontend_auth/test.sh
index 5714b41d6..d4475369f 100755
--- a/src/test/regression/tests/020.allow_clear_text_frontend_auth/test.sh
+++ b/src/test/regression/tests/020.allow_clear_text_frontend_auth/test.sh
@@ -31,6 +31,9 @@ echo "allow_clear_text_frontend_auth = on" >> etc/pgpool.conf
 #set max_init_children to 1 to make sure we reuse the
 #connection to test wrong password rejection
 echo "num_init_children = 1" >> etc/pgpool.conf
+# set synchronous replication to avoid replication delay
+echo "synchronous_commit = remote_apply" >> data0/postgresql.conf
+echo "synchronous_standby_names = 'server1'" >> data0/postgresql.conf
 
 ./startall
 
diff --git a/src/test/regression/tests/022.pool_passwd_alternative_auth/test.sh b/src/test/regression/tests/022.pool_passwd_alternative_auth/test.sh
index 00b4988ff..47498e651 100755
--- a/src/test/regression/tests/022.pool_passwd_alternative_auth/test.sh
+++ b/src/test/regression/tests/022.pool_passwd_alternative_auth/test.sh
@@ -33,6 +33,9 @@ echo "allow_clear_text_frontend_auth = off" >> etc/pgpool.conf
 #connection to test wrong password rejection
 echo "num_init_children = 1" >> etc/pgpool.conf
 echo "enable_pool_hba = on" >> etc/pgpool.conf
+# set synchronous replication to avoid replication delay
+echo "synchronous_commit = remote_apply" >> data0/postgresql.conf
+echo "synchronous_standby_names = 'server1'" >> data0/postgresql.conf
 
 #create pool_passwd file
 echo "scram_user:scram_password" >> etc/pool_passwd


[parent: 3462d5e6ee12]