When a password is specified in sql-createrole or sql-alterrole, this parameter determines the algorithm to use to encrypt the password. Possible values are
scram-sha-256, which will encrypt the password with SCRAM-SHA-256, and
md5, which stores the password as an MD5 hash. The default is
Note that older clients might lack support for the SCRAM authentication mechanism, and hence not work with passwords encrypted with SCRAM-SHA-256. See auth-password for more details.
There is no good reason for this to be set to “off”.