(I have about 10 books of Phoenix and Elixir that I bought, so this ongoing headache right at the start is important for me to solve. I’ve been out of programming for several years.)

I tried 2 other ways of installing postgres. Nothing seems to solve my problem.

On home-brew I used this: brew install postgresql@17

And brew services start postgresql@17

hello/config/dev.exs

config :hello, Hello.Repo,
  username: "postgres",
  password: "postgres",
  hostname: "localhost",
  database: "hello_dev",
  stacktrace: true,
  show_sensitive_data_on_connection_error: true,
  pool_size: 10

Simply trying the hello app from the Phoenixframework.com website.

I get this:

**** (Mix) The database for Hello.Repo couldn't be created: killed**

with:

14:12:26.847 [error] :gen_statem #PID<0.336.0> terminating

** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist

(db_connection 2.7.0) lib/db_connection/connection.ex:104: DBConnection.Connection.handle_event/4

(stdlib 6.2) gen_statem.erl:3737: :gen_statem.loop_state_callback/11

(stdlib 6.2) proc_lib.erl:329: :proc_lib.init_p_do_apply/3

Queue: [internal: {:connect, :init}]

Postponed: []

State: Postgrex.Protocol

Callback mode: :handle_event_function, state_enter: false

**** (Mix) The database for Hello.Repo couldn't be created: killed**

Also role postgres does not exist I remember I used to encounter this in the past too.

Ok while typing: https://www.strangeleaflet.com/blog/elixir-phoenix-and-role-postgres-does-not-exist

Worked! Happy Day!