修改密码报错password type is not a plain text

文章目录环境症状问题原因解决方案环境系统平台Linux x86-64 Red Hat Enterprise Linux 7版本9.0.3,9.0.4,9.0.5症状修改密码报错highgo# ALTER ROLE u1 WITH SUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD md515259458841d69f32a63642549048d80; ERROR: password type is not a plain text问题原因安全插件credcheck默认情况下不允许使用密文密码。highgo# show shared_preload_libraries ;shared_preload_libraries-----------------------------------------------------------------------------------gb18030_2022,restricted_dba,pg_audit,sqlite_fdw,credcheck,pg_stat_statements4881 highgo# show credcheck.encrypted_password_allowed ;credcheck.encrypted_password_allowed--------------------------------------off解决方案psql会话中设置允许密文密码再修改密码。highgo# set credcheck.encrypted_password_allowedon;SEThighgo# ALTER ROLE u1 WITH SUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD md515259458841d69f32a63642549048d80;