Skip to content
This repository has been archived by the owner on Sep 27, 2022. It is now read-only.

Postgres error role "postgres" does not exist on running mix ecto.create #45

Open
bartvanderwal opened this issue Nov 3, 2020 · 1 comment

Comments

@bartvanderwal
Copy link

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/3
Last message: nil
State: Postgrex.Protocol
** (Mix) The database for RealWorld.Repo couldn't be created: FATAL 28000 (invalid_authorization_specification): role "postgres" does not exist
@bartvanderwal
Copy link
Author

bartvanderwal commented Nov 3, 2020

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.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant