Postgresql helm chart with initdbScripts

Question

I have the following template:

image:
  tag: "13"
postgresqlUsername: postgres
postgresqlPassword: "12345678"
postgresqlDatabase: postgres
initdbScripts:
  init: |
    CREATE USER my_app WITH PASSWORD '12345678';
    CREATE DATABASE my_db;
    GRANT ALL PRIVILEGES ON DATABASE my_db TO my_app;

Running helm install postgresql bitnami/postgresql -f conf/postgresql/postgresql.yaml
spins up the deployment with the configmap correctly, but the database "my_db" and the user "my_app" were not created.

I need to use this setup to create multiple databases and users (hence postgresqlDatabase is not enough).

How should I work with the initdbScripts or what am I doing wrong?

Have you managed to find the solution for this?

Vikas Rathore
– Vikas Rathore

2021-08-04 07:30:50 +00:00
Commented Aug 4, 2021 at 7:30 — Vikas Rathore
– Vikas Rathore, Commented Aug 4, 2021 at 7:30

Ryall · Accepted Answer · 2021-10-22 11:33:13Z

5

The script needs a file extension so it knows how to run.

Add .sql to init:

image:
  tag: "13"
postgresqlUsername: postgres
postgresqlPassword: "12345678"
postgresqlDatabase: postgres
initdbScripts:
  init.sql: | # <-- Here
    CREATE USER my_app WITH PASSWORD '12345678';
    CREATE DATABASE my_db;
    GRANT ALL PRIVILEGES ON DATABASE my_db TO my_app;

answered Oct 22, 2021 at 11:33

Ryall

12.3k11 gold badges58 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql helm chart with initdbScripts

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related