hylink/postgres repository overview

-- 配置权用户权限设置
GRANT CREATE, TEMPORARY ON DATABASE 数据库名 TO 配置权用户名;
GRANT CREATE, USAGE ON SCHEMA 模式名 TO 配置权用户名;
ALTER DEFAULT PRIVILEGES IN SCHEMA 模式名 GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO 配置权用户名;
ALTER DEFAULT PRIVILEGES IN SCHEMA 模式名 GRANT SELECT, UPDATE, USAGE ON SEQUENCES TO 配置权用户名;
ALTER DEFAULT PRIVILEGES IN SCHEMA 模式名 GRANT EXECUTE ON FUNCTIONS TO 配置权用户名;
    
-- 使用权用户权限设置
GRANT USAGE ON SCHEMA 模式名 TO 使用权用户名;
-- 下面的授权命令需要分别在管理权用户和配置权用户下执行
ALTER DEFAULT PRIVILEGES IN SCHEMA 模式名 GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO 使用权用户名;
ALTER DEFAULT PRIVILEGES IN SCHEMA 模式名 GRANT SELECT, UPDATE ON SEQUENCES TO 使用权用户名;
ALTER DEFAULT PRIVILEGES IN SCHEMA 模式名 GRANT EXECUTE ON FUNCTIONS TO 使用权用户名;

# Use root/example as user/password credentials
version: '3.1'
services:
  postgres:
    container_name: postgres
    image: hylink/postgres:12.15-alpine3.17
    restart: unless-stopped
    ports:
      - "5432:5432"
    environment:
      - POSTGRES_USER=hlk_dba
      - POSTGRES_PASSWORD=<PASSWORD>
      - POSTGRES_CONFIG_USER=config
      - POSTGRES_CONFIG_PASSWORD=<PASSWORD>
      - POSTGRES_USE_USER=use
      - POSTGRES_USE_PASSWORD=<PASSWORD>
      - PGPORT=5432
      - POSTGRES_LOGGING_COLLECTOR=on
      - POSTGRES_LOG_DESTINATION=csvlog
      - POSTGRES_LOG_STATEMENT=all
      - POSTGRES_WORK_MEM=128MB
      - MAX_CONNECTIONS=1000
    ulimits:
      nofile:
        soft: 262144
        hard: 262144
    #volumes:
      # 数据库文件
      #- /root/docker/postgres:/var/lib/postgresql/data