You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Sep 27, 2022. It is now read-only.
I'm a postgres noob and when following the README.md to run this locally on my macbook.
But on running the mix ecto.create command I get below error about a role "postgres" does not exist.
I have installed postgres using brew (and started it using pg_ctl -D /usr/local/var/postgres start as brew suggests after successful install).
14:37:22.569 [error] GenServer #PID<0.516.0> terminating** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification): role "postgres" does not exist (db_connection 1.1.3) lib/db_connection/connection.ex:163: DBConnection.Connection.connect/2 (connection 1.0.4) lib/connection.ex:622: Connection.enter_connect/5 (stdlib 3.13.2) proc_lib.erl:226: :proc_lib.init_p_do_apply/3Last message: nilState: Postgrex.Protocol** (Mix) The database for RealWorld.Repo couldn't be created: FATAL 28000 (invalid_authorization_specification): role "postgres" does not exist
The text was updated successfully, but these errors were encountered:
I managed to fix this issue by changing the value of the username setting in the copied config/dev.exs file (step 2 of the install. I changed it from postgres to my macos username (which apparently is the default on macOS after install, as mentioned I'm a postgres noob, so took some googling). You should change the password as well (the default password is empty so set password: "",).
I also noted that the setting in the react-redux version of the front-end is called API_ROOT instead of API_URL as the README.md mentions. This might change between implementations; but maybe you could mention both.
I hope this helps others. As mentioned in #42 the docs could be more helpful 😄. Would you accept a pull request of your README.md with these fixes this? I'd like to save others this half hour of their live :smile.
I'm a postgres noob and when following the
README.md
to run this locally on my macbook.But on running the
mix ecto.create
command I get below error about arole "postgres" does not exist
.I have installed postgres using brew (and started it using
pg_ctl -D /usr/local/var/postgres start
as brew suggests after successful install).The text was updated successfully, but these errors were encountered: