Meatsploit postgresql连接失败 显示：postgresql selected, no connection

Kali/Parrot系统msf postgresql连接失败 显示：postgresql selected, no connection

前不久刚换了个Parrot系统，很炫酷的os。

可是测试Metasploit的数据库的时候出问题了，用

┌─[root@parrot]─[/home/huang]
└──╼ #/etc/init.d/postgresql start
[ ok ] Starting postgresql (via systemctl): postgresql.service.

启动服务没有问题.

msf > db_connect postgres:toor@127.0.0.1/msf
msf > db_status
[*] postgresql selected, no connection

输入账户密码，可就是显示没有数据库连接。
按照常规思想，应该是账号密码错了，自己修改一个再连接，还是no connection。我查了查资料，应该用“msfdb reinit”来初始化，可初始化都失败了。
冷静一下，分析一下log。

┌─[root@parrot]─[/home/huang]
└──╼ #msfdb reinit
[i] Database already started
[+] Dropping databases 'msf'
[+] Dropping databases 'msf_test'
[+] Dropping database user 'msf'
[+] Deleting configuration file /usr/share/metasploit-framework/config/database.yml
[+] Stopping database
[+] Starting database
[+] Creating database user 'msf'
[+] Creating databases 'msf'
[+] Creating databases 'msf_test'
[+] Creating configuration file '/usr/share/metasploit-framework/config/database.yml'
[+] Creating initial database schema
rake aborted!
PG::ConnectionBad: could not connect to server: Connection refused
 Is the server running on host "localhost" (::1) and accepting
 TCP/IP connections on port 5432?
could not connect to server: Connection refused
 Is the server running on host "localhost" (127.0.0.1) and accepting
 TCP/IP connections on port 5432?

最后几行是关键，系统发问了，服务是运行在本地并且接受连接到端口5432吗？
这是配置文件出问题了啊！
用“locate”命令，定位文件postgresql.conf

─[root@parrot]─[/home/huang]
└──╼ #locate postgresql.conf
/etc/postgresql/10/main/postgresql.conf
/lib/systemd/system/postgresql@.service.d/parrot_postgresql.conf
/usr/lib/tmpfiles.d/postgresql.conf
/usr/share/postgresql/10/postgresql.conf.sample

再用Vim打开postgresql.conf

如图：修改listen_addresses=’*’ (这行原本被注释了。。。。。)和port=5432（这是系统钦点要连接的端口。。。。。）。

然后：

OK！YOU DIDN’T SAY THE MAGIC WORD!