Setting up Postgres SQL for use with msfconsole

[ZF]

apt-get install postgresql
Edit postgresql.conf and change
listen_addresses = '*'
Edit pg_hba.conf and add
host all all 10.81.81.1/24 trust

service postgresq restart
ss -ant | grep 5432

sudo -i -u postgres psql
createuser --interactive magneto

alter user postgres with password 'newpassword'
\password postgres

//to list users and rights
\du

//list all schema
\dn

//list all databases
\list

//list all tables in current database
\dt

//connect to ndatabase
\c <db-name>


createuser --interactive pgzf
psql
create database nmap_hosts; //reproducing metasploit nmap results table