pgsql: Allow tests to pass in OpenSSL FIPS mode (TAP tests)

Allow tests to pass in OpenSSL FIPS mode (TAP tests)

Some tests using md5 authentication have to be skipped.  In other
cases, we can rewrite the tests to use a different authentication
method.

Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Reviewed-by: Daniel Gustafsson <daniel@yesql.se>
Discussion: https://www.postgresql.org/message-id/flat/dbbd927f-ef1f-c9a1-4ec6-c759778ac852%40enterprisedb.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/284cbaea7c4b89ce8685a148baeaf1d7896a900e

Modified Files
--------------
src/test/authentication/t/001_password.pl | 146 ++++++++++++++++++------------
src/test/ssl/t/002_scram.pl               |  35 ++++---
2 files changed, 112 insertions(+), 69 deletions(-)