Add support for new SCRAM-SHA-256 authentication (reader/writer PostgreSQL 10)

PostgreSQL 10 introduces a new generic SASL authentication method : SCRAM-SHA-256.

(Only SCRAM-SHA-256 is supported at the moment, but this allows adding more SASL mechanisms in the future, without changing the overall protocol.)

But FME dont support it :

ERROR |Error connecting to PostgreSQL database(host='***', port='5432', dbname='***', user='***', password='***'): 'authentication method 10 not supported' ERROR |Writer failed in open() call

So we are forced to use the not very secure old md5 method :

SET password_encryption = 'md5'; CREATE ROLE geonov PASSWORD 'md5password' LOGIN;

I would like to use the new SCRAM-SHA-256 method with FME :

SET password_encryption = 'scram-sha-256'; CREATE ROLE geonov PASSWORD 'shapassword' LOGIN;