How to Setup/Troubleshoot Postgres in Metasploit
Installation ============= If you've already installed the Postgres database and libraries, you can safely skip this section. On Ubuntu: $ sudo apt-get install postgresql-8.4 $ sudo apt-get install rubygems libpq-dev $ sudo gem install pg You may also need some / all of the following packages: # apt-get install libreadline-dev # apt-get install libssl-dev # apt-get install libpq5 # apt-get install ruby-dev For other platforms, please see the distribution's documentation for installing postgres. Become the system postgres user ================================ user@magnolia:$ sudo -s root@magnolia:# su postgres Creating a database user ========================= postgres@magnolia:$ createuser msf_user -P Enter password for new role: Enter it again: 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 Creating a database ================...