pgsql: Backport BackgroundPsql perl test module

Backport BackgroundPsql perl test module

Backport the new BackgroundPsql modules and the constructor functions,
background_psql() and interactive_psql, to all supported
branches. That makes it easier to backpatch tests that use it.

BackgroundPsql was introduced in version 16. On version 16, this
commit backports just the new timeout argument from master (commit
334f512f45). On older branches, the whole facility. This includes the
change to `use warnings FATAL => 'all'`, which we haven't otherwise
backported, but it seems good to keep the file identical across
branches.

Discussion: https://www.postgresql.org/message-id/b7c64f20-ea01-4f15-9088-0cd6832af149@iki.fi

Branch
------
REL_16_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/187b8991f70fc3d2a13dc709edd408a8df0be055

Modified Files
--------------
src/test/perl/PostgreSQL/Test/BackgroundPsql.pm | 14 ++++++++------
src/test/perl/PostgreSQL/Test/Cluster.pm        | 11 ++++++++---
2 files changed, 16 insertions(+), 9 deletions(-)