The default Phoenix setup uses username and password set to “postgres”. The problem is that vanilla PostgreSQL setup does not have this particular password set for the superuser role “postgres”. Either:
- set the desired password (“postgres”) for the user/role “postgres”
- add your own user (role) to the DB with your own username and password. Give it only necessary privileges, and update the
dev.exs(or other, appropriate config file) accordingly
I always do the latter. YMMV.
