docker-compose.yml

  1. postgres:
  2. image: postgres
  3. restart: always
  4. ports:
  5. - "5432:5432"
  6. environment:
  7. - POSTGRES_PASSWORD=jiang155.
  8. volumes:
  9. - ./postgres/data:/var/lib/postgresql/data

语法

  1. # 创建数据库
  2. create database nextcloud;
  3. # 创建用户
  4. CREATE USER nextcloud WITH PASSWORD 'nextcloud';
  5. # 赋权
  6. GRANT ALL PRIVILEGES ON DATABASE nextcloud TO nextcloud;