- Change all instances where you find the following comment
-- UPDATE THIS PATH WITH YOUR OWN!
- Update it with your own ABSOLUTE path to the
migration.sql
file
dropdb allthemovies
createdb allthemovies
psql -d allthemovies -f ./db/migration.sql
- create a
.env
file at the root of your project - add the following info (UPDATE
USER=
with your username):
DB_HOST=localhost DB_USER= DB_PASS= DB_NAME=allthemovies DB_PORT=5432 NODE_ENV=development
- in the terminal type:
npm install
(from the root of your project)
\du
to see all users (inside psql)