Mix setup on macOS leads to "role "postgres" does not exist"

[raffaelschneider]

Setup

• macOS Ventura 13.4
• Elixir 1.14.4, Erlang/OTP 25 (erts-13.2.2)
• cmark-gfm (0.29.0.gfm.13) compiled and installed

Issue I tried to setup the project as described with $ mix setup and get the following log output.

Log output

`12:19:57.826 [debug] Downloading tailwind from https://github.com/tailwindlabs/tailwindcss/releases/download/v3.1.8/tailwindcss-macos-arm64

12:20:03.508 [debug] Downloading esbuild from https://registry.npmjs.org/esbuild-darwin-arm64/-/esbuild-darwin-arm64-0.14.41.tgz

12:20:03.901 [error] Postgrex.Protocol (#PID<0.616.0>) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist

12:20:03.907 [error] Postgrex.Protocol (#PID<0.621.0>) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist
** (Mix) The database for BeaconDemo.Repo couldn't be created: killed`

[leandrocp]

Hi @raffaelschneider you can edit the database configuration to reflect your environment or you can create that user if it's missing:

CREATE USER postgres WITH PASSWORD 'postgres';