bhubr/psql-quickstart-macos.md

Last active March 26, 2024 20:54

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/bhubr/da99154446b20c828118c82bff6e9e5a.js"></script>
Save bhubr/da99154446b20c828118c82bff6e9e5a to your computer and use it in GitHub Desktop.

Download ZIP

PostgreSQL quickstart macOS/homebrew

Raw

psql-quickstart-macos.md

PostgreSQL quickstart macOS/homebrew

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

install: brew install postgres
initdb /usr/local/var/postgres
/usr/local/Cellar/postgresql@11/11.22_1/bin/createuser -s postgres

Run psql -U postgres

init db

CREATE ROLE app_ecommerce_nodejs WITH LOGIN PASSWORD 'passwd';
CREATE DATABASE app_ecommerce_nodejs OWNER app_ecommerce_nodejs;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment