pgsql: Make 009_twophase.pl test pass with recovery_min_apply_delay set

Make 009_twophase.pl test pass with recovery_min_apply_delay set

The test failed if you ran the regression tests with TEMP_CONFIG with
recovery_min_apply_delay = '500ms'. Fix the race condition by waiting
for transaction to be applied in the replica, like in a few other
tests.

The failing test was introduced in commit cbfbda7841. Backpatch to all
supported versions like that commit (except v12, which is no longer
supported).

Reported-by: Alexander Lakhin
Discussion: https://www.postgresql.org/message-id/[email protected]

Branch
------
REL_17_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/d1253c67fa29a8cfd15874f9154ddf86e05921a9

Modified Files
--------------
src/test/recovery/t/009_twophase.pl | 1 +
1 file changed, 1 insertion(+)