dxw / local-env

Get set up quickly for working with software at dxw
MIT License
3 stars 0 forks source link

Add postgres user #18

Closed dragon-dxw closed 2 years ago

dragon-dxw commented 2 years ago

Brew doesn't set up a postgres user.

Add /usr/local/opt/postgres/bin/createuser -s postgres || true to the setup script (it will fail if the user already exists)

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

erbridge commented 2 years ago

So after doing a fresh Postgres reinstall, I needed to create a DB for my user (not postgres). I did that via createdb (no arguments).

yndajas commented 2 years ago

/usr/local/opt/ is the Intel/x86 path, but I ended up doing this instead:

erbridge commented 2 years ago

https://github.com/dxw/local-env/pull/19#issuecomment-964125616