Hello,
I have just re-tested my own setup and indeed it works!
Previously, while have ensured client & server PG v10 compatibility + pg_hba configs, I have forgot to ALTER roles so that hashing algo (rolpassword) reflects `password_encryption` configuration option.
Now when `select * from pg_authid;` returns rolpasswords prefixed with 'SCRAM-SHA-256$' connections from ruby-pg do succeed.
On Tue, Jan 02, 2018 at 03:26:16PM +0100, Lars Kanis wrote:
> Hi Aleksandrs,
>
> SCRAM authentication can only be used, if you use PostgreSQL-10 server and
> client library (libpq) and ruby-pg must be linked to a libpq version of
> PostgreSQL-10.
>
> There are two parts of use:
> (1) Setting a password of a user and
> (2) Verification of a password of a user.
>
> (1) will use SCRAM when the password is given in cleartext and
> password_encryption
> <
https://www.postgresql.org/docs/10/static/runtime-config-connection.html#GUC-PASSWORD-ENCRYPTION>
--
Best,
Aleksandrs Ļedovskis