I've spent a lot of time trying to get my autopwn working after numerous issues with the database drivers. Here's what I did to get it fully functional.

Prerequisites:
1. You have postgresql installed and you have a valid username and password.

-------------------------------------------------------------
1. Open autopwn.py in gedit (or nano).
#gedit /pentest/exploits/fasttrack/bin/ftsrc/autopwn.py

2. Scroll to the bottom.

Code:
# define metasploit path
meta_path=file("%s/config/fasttrack_config" % (definepath),"r").readlines()
for line in meta_path:
    line=line.rstrip()
    match=re.search("METASPLOIT_PATH",line)
    if match:
       line=line.replace("METASPLOIT_PATH=","")
       metapath=line
#------------ ABOVE THIS LINE HAS NOT BEEN MODIFIED ------------
try:
   dropdb = pexpect.spawn('dropdb -e -U postgres -W pentest')
   dropdb.expect('Password:')
   dropdb.sendline('toor')
   print "\nExisting database destroyed\n"
# replace postres with your username and pentest with your database
# replace toor with your password associated with that username
# at this point the database should be destroyed...

except Exception:
   print "\nDatabase could not be destroyed.\n"
# ...or we fail

try:
# spawn msfc
   child1 = pexpect.spawn('%smsfconsole' % (metapath))
# load postgresql driver
   child1.sendline ('db_driver postgresql')
# connect to new db with your credentials and database
   child1.sendline('db_connect postgres:toor@127.0.0.1/pentest')
# run port scans
   child1.sendline ('''db_nmap %s ''' % (ipaddr))
# run exploitation phase
   child1.sendline ('db_autopwn -p -t -e %s' % (option1))
   child1.sendline ('sleep 5')
   child1.sendline ('jobs -K')
   child1.sendline ('\n\n\n')
   child1.sendline ('sessions -l')
# jump to pid
   child1.interact()
except Exception:
       print "\n    Exiting Fast-Track...\n"
Enjoy.