1、今天在数据库全面升级之后，用新版msf连接新版postgresql时出现了告警
警告: database "msf" has a collation version mismatch
DETAIL: The database was created using collation version , but the operating system provides version .
(相关资料图)
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/
连接方式
db_connect username:password@localhost:端口号/数据库名
