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
> 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