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 ! :)

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 :)