postgresql - 在 Windows 10 中执行时，Docker 容器关闭并出现 'data directory has wrong ownership' 错误

Question

我在 Windows 中安装了我的 docker。我正在尝试安装 this应用。它给了我以下 docker-compose.yml 文件:

version: '2'

services:
  web:
    build:
      context: .
      dockerfile: Dockerfile-nginx
    ports:
    - "8085:80"
    networks:
      - attendizenet
    volumes:
      - .:/usr/share/nginx/html/attendize
    depends_on:
      - php
  php:
    build:
      context: .
      dockerfile: Dockerfile-php
    depends_on:
      - db
      - maildev
      - redis
    volumes:
      - .:/usr/share/nginx/html/attendize
    networks: 
      - attendizenet
  php-worker:
    build:
      context: .
      dockerfile: Dockerfile-php
    depends_on:
      - db
      - maildev
      - redis
    volumes:
      - .:/usr/share/nginx/html/attendize
    command: php artisan queue:work --daemon
    networks:
      - attendizenet
  db:
    image: postgres
    environment:
      - POSTGRES_USER=attendize
      - POSTGRES_PASSWORD=attendize
      - POSTGRES_DB=attendize
    ports:
      - "5433:5432"
    volumes:
      - ./docker/pgdata:/var/lib/postgresql/data
    networks:
    - attendizenet
  maildev:
    image: djfarrelly/maildev
    ports:
      - "1080:80"
    networks:
      - attendizenet
  redis:
    image: redis
    networks:
      - attendizenet

networks:
  attendizenet:
    driver: bridge

所有安装都很顺利，但是 PostgreSQL 容器在启动后停止了一会儿，并出现以下错误。

2018-03-07 08:24:47.927 UTC [1] FATAL:  data directory "/var/lib/postgresql/data" has wrong ownership
2018-03-07 08:24:47.927 UTC [1] HINT:  The server must be started by the user that owns the data directory

来自 Docker Hub 的一个简单的 PostgreSQL 容器运行顺利，但是当我们尝试将卷附加到容器时发生错误。

我是 docker 的新手，所以请忽略错误的术语用法。

Answer 1

这是 Windows [1][2][3][4] 上 Postgres Docker 镜像的一个记录在案的问题。目前，似乎没有办法将 Windows 目录正确挂载为卷。您可以改为使用持久性 Docker 卷，例如:

  db:
    image: postgres
    environment:
      - POSTGRES_USER=attendize
      - POSTGRES_PASSWORD=attendize
      - POSTGRES_DB=attendize
    ports:
      - "5433:5432"
    volumes:
      - pgdata:/var/lib/postgresql/data
    networks:
    - attendizenet

volumes:
  pgdata:

其他不起作用的东西:

• 将 PGDATA 设置为子目录(参见 PGDATA Setting )

    environment:
      - PGDATA=/var/lib/postgresql/data/mnt
    volumes:
      - ./pgdata:/var/lib/postgresql/data

• 使用绑定(bind)挂载 (docker-compose 3.2)

    volumes:
      - type: bind
        source: ./pgdata
        target: /var/lib/postgresql/data

• 以 POSTGRES_USER=root 身份运行

更多信息:

GitHub

• data directory "/var/lib/postgresql/data" has wrong ownership

Docker 论坛

• postgresql-data-pgdata-has-wrong-ownership
• postgres-to-work-on-persistent-windows-mount