Cannot connect to Postgres DB
It turned out that I was creating the database and the user correctly. What I was doing wrong was not connecting to my database correctly through the Knexfile.

I looked at the docs from http://knexjs.org/

Once I adjusted the object in my knexfile to specify the database, I was able to run my migrations successfully.