Starting postgres and sqlite correctly for development about oban HOT 2 CLOSED

It looks like you have some permission issues. The default setup doesn’t specify a username or password, but you can set a DATABASE_URL with the connection parameters you need.

Here is how it’s done in CI: https://github.com/sorentwo/oban/blob/b092e278c1091319fa48d6f9d9b445ffff57edb5/.github/workflows/ci.yml#L91C35-L91C35

from oban.

Thank you @sorentwo

===

For future reference and anyone running with their DB in Docker.

Start the docker container with:

docker run --name oban -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust -e PGDATA=/var/lib/postgresql/data/pgdata postgres

You must set POSTGRES_HOST_AUTH_METHOD=trust because otherwise the database expects some password, which the tests don't specify.

Run the tests with the DATABASE_URL parameter, because otherwise it will just fail with your hostname.

DATABASE_URL=postgresql://postgres:postgres@localhost:5432/oban_test mix test.setup

The database url should be set on all invocations of mix.

from oban.