Again, very likely it’s because their docker-compose.yaml file is used for CI/CD and deployment, not for local development, that’s my hypothesis. If it was used for local dev then surely it would have the host:container port pairs.

Yes, you can reference containers by their service names, no numeric extension should be added, the name should be exactly as it is defined in docker-compose.yml.

port option is for just exposing the container port to your host, the option port: "5432" will expose port 5432 from the container on your host on 5432.

I would recommend checking that your host 5432 port is free, otherwise map to a different port:

ports:
      - "5432:5433"

Also ensure that you are not connecting to some already exsting volumes with some strange Postgres configurations, a clean postgres/postgis container will always serve on port 5432 by default.

The last and the first thing I should have mentioned is to check that the database container has started as expected, it can happen that it will not start if it’s missing some mandatory configuration options (like username), you should have logs that it started accepting clients on port 5432.

I’ve just ran the docker-compose and everything works as expected from the standpoint of database. It’s a very strange setup, but it works as expected without any issues.

What OS are you using? I’ve ran the example on ubuntu.

The only thing to keep in mind is that ecto migrations are not ran automatically, so you have to execute this command before starting the compose:

docker-compose run app mix setup

Just installed docker desktop on my mac and everything works. There is most probably an issue with your installation.

I’ve ran the following commands (note the usage of docker compose, the old command docker-compose is deprecated from long ago):

# Just because I am too lazy to setup the rabbitmq queue manually, 
# you should get errors that tables don't exist from app, 
# close after it runs for a few seconds
docker compose up 

docker compose run app mix setup
docker compose up

I’ve used such docker-compose setups a lot of times in production and there is nothing wrong with it, most probably you have some installation issues on your machine.

It is random if he didn’t change the ports part of the configuration, the version he linked to was only specifying container port which means that the host port is chosen at random every time.