May 2018
Intermediate to advanced
576 pages
30h 25m
English
To see which users don’t yet have SCRAM encrypted passwords, use this query:
test2=# select usename,passwd from pg_shadow where passwdnot like ‘SCRAM%’ or passwd is null; usename | passwd ----------+-------------- tim | weakpassword asterisk | md5chicken(2 rows)
To enable SCRAM-SHA-256 for encrypted passwords, use the following:
test2=# SET password_encryption = ‘scram-sha-256’;test2=# ALTER USER bob ENCRYPTED PASSWORD ‘whatever’; ALTER USER