Files
noahspan-vela/helm_values/postgresql.yaml
2025-01-27 17:26:43 -06:00

22 lines
738 B
YAML

global:
defaultStorageClass: standard
postgresql:
auth:
username: ${postgres_user}
password: ${postgres_password}
primary:
extraEnvVars:
- name: VELA_USER
value: ${vela_user}
- name: VELA_PASSWORD
value: ${vela_password}
initdb:
scripts:
user: ${postgres_user}
password: ${postgres_password}
db_init_script.sh: |
PGPASSWORD=$${POSTGRES_PASSWORD} psql -U $${POSTGRES_USER} <<-END
CREATE USER $${VELA_USER} WITH PASSWORD '$${VELA_PASSWORD}';
SELECT 'CREATE DATABASE vela WITH OWNER $${VELA_USER}' WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'vela')\gexec
GRANT ALL PRIVILEGES ON DATABASE vela TO $${VELA_USER};
END