metasploit+postgres using kali

>service  postgresql start
>service metasploit start
>su postgres
>createuser msf -P
Enter password for new role: yourmsfpassword
Enter it again: yourmsfpassword
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) n
Shall the new role be allowed to create more new roles? (y/n) n
createdb --owner=msf msf_database

Start the framework by running msfconsole, then enter the following commands:
msf > db_status
msf > db_connect msf:yourmsfpassword@127.0.0.1:5432/msf_database