/usr/local/opt/postgres/bin/createuser -s postgres
Fixed it for me. The problem is homebrew doesn’t install the postgres user.
GenericJam
ycherniavskyi
Got the same issue with PostgreSQL on macOS installed from brew.
Resolved with the next config:
config :p_core, PCore.Repo,
username: System.cmd("whoami", [])
|> elem(0)
|> String.trim(),
database: "p_core_dev",
hostname: "localhost",
show_sensitive_data_on_connection_error: true,
pool_size: 10
3
maxveldink
aflansburg
This ended up being my issue as well on Mac OS - I needed to replace user / password with my local machine credentials.
2
romenigld
Just create a user:
createuser --superuser postgres
check with the psql:
$ psql default
psql (14.1)
Type "help" for help.
default=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------------------+-----------
postgres | Superuser, Create role, Create DB | {}
my_username | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
4
dr.a
jamieorc
leifericf
I just stumbled on this issue after returning to Elixir/Phoenix and reinstalling everything from scratch. The solution was to change the database config username in dev.exs from postgres to my macOS username.
1
leifericf
garrison
It’s probably better to create the postgres user in order to keep your dev env portable. This is actually documented here and linked in the installation guide, but it’s easy to miss.
3