afterthefact postgre metasploit user password set

  
   
 let's just say you set up metaspoit with msf user and forget to set the password.  
 you go to msfconsole and see:  

 Failed to connect to the database: fe_sendauth: no password supplied [-] Unknown command: Failed. metasploit  
   
 crap.  

    
 $ sudo -u postgres psql  
   
 \password msf  
   
 set the password and quit  
   
 \q  
   
 edit:  
   
 $ sudo nano -w /opt/metasploit-framework/config/database.yml  
   
 On the line password: supply it.  
   
 $ echo sigh.