0

I'm deploying the https://github.com/bitnami/charts/tree/master/bitnami/postgresql into k8s and wondering how can I automate the following

  • creation of a database
  • create a role with password as owner of the database above

I've seen the extraDeploy https://github.com/bitnami/charts/blob/master/bitnami/postgresql/values.yaml#L43 parameter but this seems like will create a k8s specific resource (not touching pg).

The only idea I have leveraging the extraDeploy is to create a job which deploys a custom pod that will connect to pg and create the db, role and password ...

thanks!

silviud
  • 2,677
  • 2
  • 16
  • 19

1 Answers1

4

Bitnami Engineer here, you can use an initial script to create the database and all the things you need with initdbScripts: https://github.com/bitnami/charts/blob/931b597c43f6cd37919569acda4432a9bdd59a71/bitnami/postgresql/values.yaml#L298-L307

You can check the "Initialize a fresh instance" part of the README.md for more information.

Ibone
  • 56
  • 1
  • Thanks - I'm using the initdbScripts with a custom sql script. – silviud Aug 31 '21 at 16:25
  • initdbScripts is a nice solution. Only addition is that I needed to escape the "." in the filename/dictionary key, e.g. `01_init\.sql:` – JCotton Jan 12 '22 at 20:26