Add support for SCRAM-SHA-256 password authentication

[Sourav1407]

What would you like to be added:

The superuser and the replication user is not working with SCRAM-SHA-256 password authentication method. When the authentication method is trust or MD5 it is working but when the PostgreSQL authentication method is changed to SCRAM-SHA-256 the application is failing to connect to the database. The Stolon architecture document (https://github.com/sorintlab/stolon/blob/master/doc/architecture.md) quotes "Currently trust (password-less) and md5 password based authentication are supported. In the future, different authentication mechanisms will be added." Hence would like to have the SHA-256 encryption support added .

Why is this needed:

This is needed for enhancing the security as one of our client wants to enhance the encryption method from MD5 to SCRAM-SHA-256. We are able to implement in our non-HA ecosystem but we are not able to implement it in HA PostgreSQL as it is implemented with Stolon and the application is failing when the PostgreSQL encryption method is changed from MD5 to SHA-256.

[Sourav1407]

Any update on this? Does stolon support SCRAM-SHA-256 now

[aaranmcguire]

Just wanted to bump this. Maybe we could rebase the PR and allow the tests to run correctly?

[Neustradamus]

PR here from @jwnl88:

• Added SCRAM-SHA-256 support #834

Linked to:

• State of Play scram-sasl/info#1