pgsql: Back-Patch "Add wait_for_subscription_sync for TAP tests."

Back-Patch "Add wait_for_subscription_sync for TAP tests."

This was originally done in commit 0c20dd33db for 16 only, to eliminate
duplicate code and as an infrastructure that makes it easier to write
future tests. However, it has been suggested that it would be good to
back-patch this testing infrastructure to aid future tests in
back-branches.

Backpatch to all supported versions.

Author: Masahiko Sawada
Reviewed by: Amit Kapila, Shi yu
Discussion: https://postgr.es/m/CAD21AoC-fvAkaKHa4t1urupwL8xbAcWRePeETvshvy80f6WV1A@mail.gmail.com
Discussion: https://postgr.es/m/E1oJBIf-0006sw-SA@gemulon.postgresql.org

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/036642abc9fba59c0bec2b83923b943d21636811

Modified Files
--------------
src/test/perl/PostgresNode.pm              | 44 ++++++++++++++++++++++++++++++
src/test/subscription/t/001_rep_changes.pl |  9 ++----
src/test/subscription/t/002_types.pl       |  9 ++----
src/test/subscription/t/004_sync.pl        | 18 ++++--------
src/test/subscription/t/005_encoding.pl    |  9 ++----
src/test/subscription/t/006_rewrite.pl     |  9 ++----
src/test/subscription/t/008_diff_schema.pl | 12 ++------
src/test/subscription/t/010_truncate.pl    |  8 ++----
src/test/subscription/t/011_generated.pl   |  5 +---
src/test/subscription/t/100_bugs.pl        |  9 ++----
10 files changed, 65 insertions(+), 67 deletions(-)