Postgresql in BackTrack5 and Metasploit Framework .

I have just installed the new and improved BackTrack 5 in virtualbox. As always, i made an apt-get update && apt-get dist-upgrade -y and after that a msfupdate.

I launched Metasploit framework, and was about to start postgresql when i realized that BT 5 is with MySQL. After playing around with MySQL, i decided to install and setup PostgreSQL instead. The commands i used was:

apt-get install postgresql-8.4 rubygems libpq-dev 





gem install pg 

apt-get install libreadline-dev libssl-dev libpq5 ruby-dev 


Become the system postgres user: su postgres

creating user: createuser user -P
- enter pass twice (i wrote toor)

superuser? n

allow to create database? n

more new roles? n
Still as the postgres-user, type the following:
createdb – -owner=user msf_database

In Metasploit:

db_driver postgresql

db_connect user:password@127.0.0.1/msf_database

Verify that it works in Metasploit:

db_hosts