Postgres 14 SCRAM connection issues.

[JeremyGibson]

As of Postgres 14 scram-sha-256 is the default password authentication method. Password created during server creation use this rather than md5.

pg_hba.conf has scram-sha-256 automatically in place for local connections.

When this is in place the clients cannot connect to the server and fails with this message:

out: pg_dump: error: connection to server at "127.0.0.1", port 7432 failed: server offered SCRAM-SHA-256-PLUS authentication over a non-SSL connection

For the time being this can be fixed by changing the scram-sha-256 lines in pg_hba.conf to md5, but we should attempt to work out why the client is not connecting correctly to the server.