/opt/metasploit-framework/embedded/bin/postgres -D /home/ecarroll/.msf4/db -p 5433

pg_lsclusters
Ver Cluster Port Status Owner    Data directory               Log file
10  main    5432 online postgres /var/lib/postgresql/10/main  /var/log/postgresql/postgresql-10-main.log

PROD_PASSWORD=$(apg -n1 -q)
TEST_PASSWORD=$(apg -n1 -q)

printf "GENERATING WITH [PROD PW %s], [TEST PW %s]", "$PROD_PASSWORD", "$TEST_PASSWORD";


psql -d test <<EOF
  CREATE USER msf     WITH LOGIN password '$PROD_PASSWORD';
  CREATE USER msftest WITH LOGIN password '$TEST_PASSWORD';

  CREATE DATABASE msf     WITH OWNER = msf;
  CREATE DATABASE msftest WITH OWNER = msftest;
EOF

psql -d msf     -U msf     -h localhost
psql -d msftest -U msftest -h localhost

cat > ~/.msf4/database.yml <<EOF
development: &pgsql
  adapter: postgresql
  database: msf
  username: msf
  password: $PROD_PASSWORD
  host: 127.0.0.1
  port: 5432
  pool: 200
  timeout: 5

production: &production
  <<: *pgsql

test:
  <<: *pgsql
  database: msftest
  username: msftest
  password: $TEST_PASSWORD
EOF