Hello community!! I´m trying to spin up a K8s cluster using the helm chart provided by prefetc…amd I...

Raúl Mansilla

06/14/2021, 9:12 PM

Hello community!! I´m trying to spin up a K8s cluster using the helm chart provided by prefetc…amd I´m trying to use an external postgreSQL database. The thing is_ What should I have to write inside postgresql.externalHostname? the hole postresql url with user/password/url/port/ddbb ? or just the url?

Raúl Mansilla

06/14/2021, 9:14 PM

Copy code

# externalHostname defines the address to contact an externally
  # managed postgres database instance at. This is not required if
  # `internalPostgres` is `true`
  externalHostname: ""

Raúl Mansilla

06/14/2021, 9:15 PM

Copy code

--set postgresql.useSubChart=false --set postgresql.externalHostname=<http://prefecttesting.xxxxxxxxxxx.eu-west-1.rds.amazonaws.com|prefecttesting.xxxxxxxxxxx.eu-west-1.rds.amazonaws.com> --generate-name

Raúl Mansilla

06/14/2021, 9:15 PM

Raúl Mansilla

06/14/2021, 9:16 PM

Copy code

--set jobs.createTenant.enabled=true --set.postgresql.useSubChart=false --set.postgresql.externalHostname=<postgresql://usr:pass@prefecttesting.xxxxxxxxxxx.eu-west-1.rds.amazonaws.com:5432/prefect>

Raúl Mansilla

06/14/2021, 9:18 PM

now…in both cases hasura, apollo and towel pods do not start ->

CreateContainerConfigError

Mariia Kerimova

06/14/2021, 9:19 PM

Hello Raul! Just

<http://prefecttesting.xxxxxxxxxxx.eu-west-1.rds.amazonaws.com|prefecttesting.xxxxxxxxxxx.eu-west-1.rds.amazonaws.com>

should work 👍

Mariia Kerimova

06/14/2021, 9:20 PM

Let me know if you'll still have errors

Raúl Mansilla

06/14/2021, 9:21 PM

thanks Mariia! and the password should be set in postgresqlPassword and existingSecret?

Raúl Mansilla

06/14/2021, 9:21 PM

Copy code

# existingSecret configures which secret should be referenced
  # for access to the database. If null and `useSubChart` is
  # enabled, the secret will be generated. If using an external
  # postgres service, this value should be set to a secret
  # containing the key `postgresql-password`
  existingSecret: null

  # postgresqlPassword sets the password to be used if
  # `existingSecret` is not set. This is the password for
  # `postgresqlUsername` and will be set within the secret at
  # the key `postgresql-password`
  # postgresqlPassword: use-a-strong-password

Mariia Kerimova

06/14/2021, 9:32 PM

In this case, I would recommend to create a Kubernetes secret in your cluster with key

postgresql-password

. For example,

Copy code

apiVersion: v1
kind: Secret
metadata:
  name: mydbsecret
type: Opaque
data:
  postgresql-password: base64encodedsecret

and in your chart specify

existingSecret: mydbsecret

Raúl Mansilla

06/14/2021, 9:32 PM

thanks a lot, goint to test it 🙂

Mariia Kerimova

06/14/2021, 9:33 PM

Awesome, let me know how it goes 👍

Raúl Mansilla

06/14/2021, 9:42 PM

Oh yeah, now it works…the key was using the secret!!! Awesome support Mariia!

Mariia Kerimova

06/14/2021, 9:43 PM

I'm glad it worked 🙌

🙌 1

Raúl Mansilla

06/14/2021, 10:20 PM

one last question @Mariia Kerimova …how am I supossed to write agent.prefectLabels to get them correct…if I wrote k8s or ‘k8s’ or “k8s” I get 3 labels… 8 - k - s

Mariia Kerimova

06/14/2021, 10:21 PM

Did you include brackets

["k8s"]

? I think it takes array, and if you pass string, it will create label with each letter

Raúl Mansilla

06/14/2021, 10:21 PM

I did one time but without “” yeah, looks like it is an array

Raúl Mansilla

06/14/2021, 10:24 PM

if I write

--set agent.prefectLabels=["k8s"]

then

no matches found: agent.prefectLabels=[k8s]

Mariia Kerimova

06/14/2021, 10:39 PM

I just tested with quotes and without brackets, it worked

Raúl Mansilla

06/14/2021, 10:58 PM

😕 mine not…

Raúl Mansilla

06/14/2021, 10:59 PM

Copy code

helm install prefecthq/prefect-server --set agent.enabled=true --set agent.prefectLabels="k8s" --set jobs.createTenant.enabled=true --set postgresql.useSubChart=false --set postgresql.externalHostname=<http://prefecttesting.XXXXXXXXX.eu-west-1.rds.amazonaws.com|prefecttesting.XXXXXXXXX.eu-west-1.rds.amazonaws.com> --set postgresql.existingSecret=mydbsecret --generate-name -n prefect

Mariia Kerimova

06/15/2021, 12:35 PM

Hmm, I'm going to take another look in a few, and let you know what I'll find

Mariia Kerimova

06/15/2021, 1:03 PM

Okay, this definitely should work

--set agent.prefectLabels={k8s, test}

(you might need to set quotes like this

--set "agent.prefectLabels={k8s, test}"

if you are on unix). Let me know if you'll still have the error.

Mariia Kerimova

06/15/2021, 1:08 PM

Also, I personally would recommend to create a separate values config file for your chart, so all your changes are set in declarative way, and instead of appending

--set

flags to your install command, you can just provide

--values

flag with the file which contains your desired values.

Raúl Mansilla

06/15/2021, 9:48 PM

Hi @Mariia Kerimova! Thanks for your answers… yes, definetely the labels work with

--set "agent.prefectLabels={k8s, test}"

And yes, I will create another file for my deploys. Thanks a lot for your assistance.

👍 1

2 Views

Open in Slack

Previous Next

Prefect Community

Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.