curl https://raw.githubusercontent.com/rapid7/metasploit-omnibus/master/config/templates/metasploit-framework-wrappers/msfupdate.erb > msfinstall
chmod 755 msfinstall
./msfinstall

wget https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-redhat11-11-2.noarch.rpm
rpm -ivh pgdg-redhat11-11-2.noarch.rpm

yum install postgresql11 postgresql11-server postgresql11-devel

/usr/pgsql-11/bin/postgresql-11-setup initdb

systemctl start postgresql-11
systemctl enable postgresql-11

sudo -u postgres psql

create user msf_test with password 'youpass' nocreatedb;
create database msf1 with owner ='msf_test';
\q

vim /var/lib/pgsql/11/data/pg_hba.conf

# "local" is for Unix domain socket connections only
local   all             all                                     md5
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5

systemctl restart postgresql-11

vim /opt/metasploit-framework/database.yml

production:
 adapter: postgresql
 database: msf1
 username: msf_test
 password: youpass
 host: 127.0.0.1
 port: 5432
 pool: 75
 timeout: 5

echo export MSF_DATABASE_CONFIG=/opt/metasploit-framework/database.yml >> /etc/bashrc
source ~/.bashrc