pgpool2.git / summary / log / commit / refs

commit    f925da8e291d2f53df43bae678dbc197868d3163
Author:   Tatsuo Ishii <ishii@postgresql.org>
Date:     Sun Oct 18 13:07:42 2026 +0000

    Test: stabilize 021.pool_passwd_auth.
    
    The test uses 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/021.pool_passwd_auth/test.sh | 3 +++ 1 file changed, 3 insertions(+) diff --git a/src/test/regression/tests/021.pool_passwd_auth/test.sh b/src/test/regression/tests/021.pool_passwd_auth/test.sh index c947faa57..d7d87add4 100755 --- a/src/test/regression/tests/021.pool_passwd_auth/test.sh +++ b/src/test/regression/tests/021.pool_passwd_auth/test.sh @@ -43,6 +43,9 @@ export PGPOOLKEYFILE=$PWD/etc/pgpool_key #echo "md5_user:md5_password" >> etc/pool_passwd $PG_ENC -m -f etc/pgpool.conf -u scram_user scram_password $PG_ENC -m -f etc/pgpool.conf -u md5_user md5_password +# set synchronous replication to avoid replication delay +echo "synchronous_commit = remote_apply" >> data0/postgresql.conf +echo "synchronous_standby_names = 'server1'" >> data0/postgresql.conf #copy the pool_hba to etc dir cp ../pool_hba.conf etc/ [parent: 106613a0be94]