# values-postgresql.yaml (Helm chart: bitnami/postgresql)
# 命名空间: shared-base

auth:
  postgresPassword: "<CHANGE_ME_postgres_password>"
  username: "postgres"
  password: "<CHANGE_ME_postgres_password>"
  database: "postgres"

primary:
  persistence:
    enabled: true
    size: 50Gi
    storageClass: ""  # 使用默认 StorageClass

  resources:
    requests:
      cpu: 200m
      memory: 512Mi
    limits:
      cpu: "1"
      memory: 1Gi

# 为业务应用创建独立数据库和用户
initdbScripts:
  create_databases.sql: |
    -- 创建业务数据库
    CREATE DATABASE gitea;
    CREATE DATABASE bookstore_db;
    CREATE DATABASE stock_db;
    CREATE DATABASE words_db;
    CREATE DATABASE gmc_new_db;

    -- 创建应用用户
    CREATE USER gitea_app WITH PASSWORD '<CHANGE_ME_gitea_password>';
    CREATE USER bookstore_app WITH PASSWORD '<CHANGE_ME_bookstore_password>';
    CREATE USER stock_app WITH PASSWORD '<CHANGE_ME_stock_password>';
    CREATE USER words_app WITH PASSWORD '<CHANGE_ME_words_password>';
    CREATE USER gmc_new_app WITH PASSWORD '<CHANGE_ME_gmc_password>';

    -- 授权
    GRANT ALL PRIVILEGES ON DATABASE gitea TO gitea_app;
    GRANT ALL PRIVILEGES ON DATABASE bookstore_db TO bookstore_app;
    GRANT ALL PRIVILEGES ON DATABASE stock_db TO stock_app;
    GRANT ALL PRIVILEGES ON DATABASE words_db TO words_app;
    GRANT ALL PRIVILEGES ON DATABASE gmc_new_db TO gmc_new_app;

metrics:
  enabled: true