Adminer + Postgres docker-compose

docker-compose.yml

---
version: "3.3"
services:
  # POSTGRES: https://github.com/docker-library/postgres
  db:
    image: postgres
    container_name: db
    #restart: always
    environment:
      POSTGRES_USER: ${POSTGRES_USER}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
    # exposes 5432
    networks: ["stack"]
    ports: ["5432:5432"]
    volumes:
      - db-data:/var/lib/postgresql/data
      - db-conf:/etc/postgresql
  adminer:
    container_name: adminer
    image: adminer
    #restart: always
    ports:
      - 8080:8080
    networks: ["stack"]

# Needed for windows. Might be better to uncomment on linux/prod ; check for local
volumes:
  db-data:
    driver: local
  db-conf:
    driver: local

simplified version:

---
version: "3.3"
services:
  # POSTGRES: https://github.com/docker-library/postgres
  pg:
    image: postgres
    container_name: pg
    #restart: always
    environment:
      POSTGRES_USER: ${POSTGRES_USER}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
      POSTGRES_DB: robusta_pg
    # exposes 5432
    ports: ["5432:5432"]

  my:
    image: mysql:8.0.3
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: ${MYSQL_PASSWORD}
      MYSQL_DATABASE: robusta
    ports: ["3306:3306"]

  adminer:
    container_name: adminer
    image: adminer
    #restart: always
    ports:
      - 8080:8080

MySql is sometimes already used by ubuntu system and difficult/unwanted to remove. In that case change local port, but not the docker one

   ports: ["6306:3306"]

In that case, your code will make SQL queries to 6306 port on your computer, but it will be transferred to the 3306 on docker container.

It's a hack for quick test, not recommanded as you will quickly diverge from a prod environment.

SQLSTATE[08006] [7] connection to server at "127.0.0.1", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections?