msf连接postgresql时因排序规则版本不匹配导致无法连接

1、今天在数据库全面升级之后，用新版msf连接新版postgresql时出现了告警

警告:  database "msf" has a collation version mismatch

DETAIL:  The database was created using collation version 2.36, but the operating system provides version 2.37.

HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE msf REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.

大意是数据库的排序规则版本和安装的版本不匹配，需要更新一下

sudo -u postgres psql -U postgres -d msf

REINDEX DATABASE msf;

ALTER DATABASE msf REFRESH COLLATION VERSION;

完成，可以连接了

补充：postgresql数据库账号密码获取

cat /usr/share/metasploit-framework/config/database.yml

连接方式

db_connect username:password@localhost:端口号/数据库名