Docker compose Postgres Adminer

docker-compose.yml

version: '3.1'
services :
  db:
    image: postgres:10-alpine
    ports:
      - "5432:5432"
    environment:
      POSTGRES_USER: user1
      POSTGRES_PASSWORD: changeme
      POSTGRES_DB: tododb
  admin:
    image: adminer
    restart: always
    depends_on: 
      - db
    ports:
      - 8080:8080

Thank you!
I'll implement this in an SQL course over Pay With Docker platform to provide environment for the students.

Your example is with postgres and adminer in same docker-compose.yml. How should I set adminer hostname and networks if I want to use adminer on other postgres container on same server?

docker-compose.yml for reverse proxy in which I want to add Adminer

services:
  traefik:
    image: "traefik:v2.5.6"
    networks:
      - proxy
  ...

  adminer:
    image: adminer:4.8.1-standalone
    networks:
      - proxy
    labels:
      - "traefik.http.routers.adminer.rule=Host(`adminer.${DOMAIN}`)"
      - "traefik.http.services.adminer.loadbalancer.server.port=8080"

networks:
  proxy:
    external: true

docker-compose.yml for my app, Adminer should connect to this Postgres container

 app:
    depends_on:
      - postgres-db-prod
  ...
    networks:
      - proxy
      - internal

  postgres-db-prod:
    image: postgres:14-alpine
    container_name: postgres-db-prod
    restart: unless-stopped
    ports:
      - 5432:5432
    volumes:
      - ./prisma/pg-data:/var/lib/postgresql/data
    env_file:
      - .env.local
    labels:
      - 'traefik.enable=false'
    networks:
      - proxy
      - internal

networks:
  proxy:
    external: true
  internal:
    external: false

@nemanjam This example was originally made only for local use.

Thank you so much !

When I try and log into the database I run into this issue, not sure what's causing it

Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host "localhost"
(127.0.0.1) and accepting TCP/IP connections on port 5432? could not connect to server: Cannot assign requested address Is the server
running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?

I figured out the issue was that I was trying to connect to the wrong server name. I used the name of the container and it worked.

Thanks!

@DavidSolus, thanks 👍

@DavidSolus thanks! It helped me :)