https://outerbounds.com/ logo
Join Slack
Powered by
Super quick question for all the folks: We are in...
# ask-metaflow
s
Super quick question for all the folks: We are interested in using the helm chart in GKE for metaflow with a separate custom postgresql install. Do I just populate the values.yaml in the top level of the helm chart as follows
Copy code
postgresql:
  # postgresql.enabled -- Flag to install Postgresql
  enabled: false
  postgresqlPassword: mysecretpassword
  postgresqlDatabase: my-psql-db (instance-id)
  postgresqlUsername: mypostgresqluser
or does 
postgresqlDatabase
need to be 
my-project-id:my-region:my-psql-db
? or something else.
✅ 1
a
so that whole 
postgresql:
section is a subchart bitnami/postgresql which is included for convenience. If you're using a separate postgresql managed by you (or GKE managed postgres etc.), just set enabled to false and other parameters don't matter
what you do want is the section above, to tell metadata service and UI how to connect to your db:
Copy code
metaflow-service:
  metadatadb:
    password: metaflow
    name: metaflow
    user: metaflow
    host: ...

metaflow-ui:
  metadatadb:
    password: metaflow
    name: metaflow
    user: metaflow
    host: ...
(unfortunately you have to pass it twice)
s
Thanks for responding!!
So I point both at my db?
and what goes in those sections?
how does it know the schema to apply? Does that come from metaflow?
a
I'm not sure about GKE but postgresqlDatabase is the database name . There can be several "databases" within one Postgres server. I know AWS RDS creates database named 
postgres
if you don't specify the name.
as for db schema: metadata service runs migrations and creates tables when it comes up. There is a parameter in service sub chart that controls that
👍 1
you can see the default is to try to run the migrations every time it comes up, which is usually fine, so you can leave that parameter as default
👍 1
s
great, 
db-migrations
has been crashing and we figured out that it was a bad postgresql configuration
so my thinking is that i build and configure my own postgresql separate from whatever is in the template
thanks for your help @narrow-lion-2703
👍 1
@average-beach-28850 I don't know if you're still watching this thread, but I'm having trouble connecting to the cloudsql and I figure it has something to do with the way I handle secrets
2 Views
Open in Slack
PreviousNext
Powered by