How to setup postgresql properly for phoenix defaults

grants.sql

# run psql command to get to this
# Replace APP_NAME with application name
grant all privileges on database APP_NAME_dev to postgres;
grant all privileges on database APP_NAME_test to postgres;

intial_db_setup.sh

# where APP_NAME is app name.
createuser -P postgres
createdb APP_NAME_dev
createdb APP_NAME_test

Of course the order of files is wrong. grants.sql is run second.

So apparently when I tried to run tests it required a bit more capabilities.

I ran psql with my superuser and then ran ALTER ROLE postgres CREATEDB;