search

Unleash / helm-charts

Contains helm-charts for Unleash
Apache License 2.0
41 stars 56 forks source link

Support for PostgreSQL Schema #84

Closed roman-supy-io closed 1 year ago

roman-supy-io commented 1 year ago

Describe the feature request

Please allow specifying dbConfig.schema property on values.yaml

Background

Right now it's not possible to configure the chart with custom schema: property, therefore all tables get created in public schema, which is inconvenient, since there are a lot of system tables and those Unleash creates cannot be determined (e.g. for data migration to another db instance).

Solution suggestions

dbConfig:
  # if postgres dependency chart is used, this needs to be the same value as postgresql.postgresqlDatabase
  database: unleash-db
+ schema: unleash
  ...
nunogois commented 1 year ago

Thanks for opening this issue @roman-supy-io, I'll share with the rest of the team and we'll get back to you soon!

chriswk commented 1 year ago

There is a workaround, you can put DATABASE_SCHEMA as an environment variable. I've started #85 to add support for dbConfig.schema as well.