Well, I was restless therefore I have re-installed fresh copy of kali linux. May be some other people will get the errors after upgrading to kali sana.

I have solved the bug, but I don't know where can I submit the patch.

The solution is adding some parameters on the 57 line in msfdb.

• printf "%s\n%s\n" "$DB_PASS" "$DB_PASS" | pg_cmd createuser -P $DB_USER >/dev/null

• printf "%s\n%s\n" "$DB_PASS" "$DB_PASS" | pg_cmd createuser -s -d -P $DB_USER >/dev/null

I am not sure whether the new user should be superuser or not, I just pick the parameters as I think suit.

Well, after a few tests, I think there may be also nessary to add following codes at the end of msfdb init:

rm /opt/metasploit/apps/pro/ui/config/database.yml
ln -s /usr/share/metasploit-framework/config/database.yml /opt/metasploit/apps/pro/ui/config/database.yml

However, I think the best solution should be: if you upgrade from 1.x to Kali Sana, don't execute msfdb, it's useless......

well thanks, but it is not only msf. After upgrade to kali sana there are other things too which are missing. You can check out the forum link I have provided.

I have just uploaded metasploit-framework 4.11.4-2015071403-0kali3 to fix this issue. It will shortly land in sana.