# PostgreSQL quickstart macOS/homebrew

<https://stackoverflow.com/questions/15301826/psql-fatal-role-postgres-does-not-exist>

1. install: `brew install postgres`
2. `initdb /usr/local/var/postgres`
3. `/usr/local/Cellar/postgresql@11/11.22_1/bin/createuser -s postgres`

Run `psql -U postgres`

## init db

1. `CREATE ROLE app_ecommerce_nodejs WITH LOGIN PASSWORD 'passwd';`
2. `CREATE DATABASE app_ecommerce_nodejs OWNER app_ecommerce_nodejs;`