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_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/5afa63f0aed96a8978489bdba38ef9998bb3aef0

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/013_partition.pl   | 20 ++++----------
src/test/subscription/t/100_bugs.pl        | 14 ++--------
11 files changed, 72 insertions(+), 85 deletions(-)