PostgreSQL quickstart macOS/homebrew

psql-quickstart-macos.md

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;