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_10_STABLE

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

Modified Files
--------------
src/test/perl/PostgresNode.pm | 44 ++++++++++++++++++++++++++++++
src/test/subscription/t/001_rep_changes.pl | 5 +---
src/test/subscription/t/002_types.pl | 5 +---
src/test/subscription/t/004_sync.pl | 14 +++-------
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/100_bugs.pl | 9 ++----
8 files changed, 59 insertions(+), 48 deletions(-)