1、今天在數(shù)據(jù)庫全面升級(jí)之后，用新版msf連接新版postgresql時(shí)出現(xiàn)了告警

警告: ?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.

?

大意是數(shù)據(jù)庫的排序規(guī)則版本和安裝的版本不匹配，需要更新一下

sudo -u postgres psql -U postgres -d msf

REINDEX DATABASE msf;

ALTER DATABASE msf REFRESH COLLATION VERSION;

完成，可以連接了

補(bǔ)充：postgresql數(shù)據(jù)庫賬號(hào)密碼獲取

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

連接方式

db_connect username:password@localhost:端口號(hào)/數(shù)據(jù)庫名