docker-compose.yml

services:
  db:
    build: .
    container_name: yp-sql-db
    restart: unless-stopped
    env_file:
      - .env
    environment:
      - LANG=ru_RU.UTF-8
      - LC_ALL=ru_RU.UTF-8
      - LC_MESSAGES=ru_RU.UTF-8
      - POSTGRES_INITDB_ARGS=--encoding=UTF8 --locale=ru_RU.UTF-8 --lc-messages=ru_RU.UTF-8
    command: >
      postgres
      -c shared_preload_libraries=pg_stat_statements
    ports:
      - "3308:5432"
    volumes:
      - pgdata:/var/lib/postgresql/data
      - ./initdb:/docker-entrypoint-initdb.d:rw


  pgadmin:
    image: dpage/pgadmin4:8
    container_name: yp-pgadmin
    restart: unless-stopped
    environment:
      PGADMIN_DEFAULT_EMAIL: admin@example.com
      PGADMIN_DEFAULT_PASSWORD: admin
      PGADMIN_CONFIG_SERVER_MODE: "False"
    ports:
      - "9080:80"             # внешний порт для pgAdmin
    depends_on:
      - db
    volumes:
      - pgadmin-data:/var/lib/pgadmin

volumes:
  pgdata:
  pgadmin-data: