PostgreSQL in Helm: initdbScripts Parameter

According to stable/postgresql helm chart, initdbScripts is a dictionary of init script names which are multi-line variables:

## initdb scripts
## Specify dictionary of scripts to be run at first boot
## Alternatively, you can put your scripts under the files/docker-entrypoint-initdb.d directory
##
# initdbScripts:
#   my_init_script.sh:|
#      #!/bin/sh
#      echo "Do something."

Let's assume that we have the following init.sql script:

CREATE USER helm;
CREATE DATABASE helm;
GRANT ALL PRIVILEGES ON DATABASE helm TO helm;

When we are going to inject a multi-line text into values we need to deal with indentation in YAML.

For above particular case it is:

helm install stable/postgresql -n testpg \
--set global.postgresql.postgresqlDatabase=testpg \
--set global.postgresql.postgresqlUsername=testpg \
--set global.postgresql.postgresqlPassword=testpg \
--set global.postgresql.servicePort=5432 \
--set initdbScripts."init\.sql"="CREATE USER helm;
CREATE DATABASE helm;
GRANT ALL PRIVILEGES ON DATABASE helm TO helm;" \
--set service.type=LoadBalancer

There is some explanation to above example:

1. If script's name has . it should be escaped, like "init\.sql".
2. Script's content is in double quotes, because it's multi-line string variable.

Here's what @nickgryg's answer looks like with values.yaml instead of command line switches.

primary:
  initdb:
    scripts:
      init.sql: |
        CREATE USER helm;
        CREATE DATABASE helm;
        GRANT ALL PRIVILEGES ON DATABASE helm TO helm;

If you are using "hashicorp/helm" provider on terraform you can use something like this:

resource "helm_release" "postgres" {
  name      = "postgres"
  chart     = "bitnami/postgresql"
  version   = "13.2.0"
  set {
    name  = "primary.initdb.scripts"
    value = "init_dbs.sql: CREATE USER my_user; CREATE DATABASE my_db; GRANT ALL PRIVILEGES ON DATABASE my_db TO my_user;"
  }
}