one last question for today I promise Now Dagit is running p

Question

one last question for today I promise Now Dagit is running perfectly with your helm chart but when I try to run a pipeline by hand in Dagit s Playground I got an error complaining about PGSQL should I drop the database and recrate or DB housekeeping is always done by Dagit service I mean if something is wrong in the database I put some stuff into the thread

Istvan Darvas · Answer

I got this error when I try to start the pipeline from Dagit s playground

Istvan Darvas · Answer

what should I check drop purge DB and let Dagit repopulate it with its schema

Istvan Darvas · Answer

in local with local Dagit this is running seamlessly

Istvan Darvas · Answer

These are the modules I use in dagit s python env

prha · Answer

This looks less like a schema issue and more of a connection issue In your deployed dagit does it have access to the PG credentials it needs to connect This would need to be configured in your `dagster yaml`

Istvan Darvas · Answer

I would say yes but i have to test this if i want to say with 100 so I need to install some client into that container i will report back this to you here if I checked out thanks for the advice < prha>

Istvan Darvas · Answer

< prha> you are right thanks I have to revisit the helm chart because the credentials are missing from the dagster s config wink OMG tomorrow I am going to fix this my custom pg resource got the credential only wink thanks again

prha · Answer

oh good glad you were able to track that down

Istvan Darvas · Answer

< prha> pg password was a very good advice because it was missing but now it is configured and I also test the connection still no luck

Istvan Darvas · Answer

this is the dagster config totally default

Istvan Darvas · Answer

here is the connection test from dagit the 1st line needs because psql has this stupid pwPassByEnv feature So I used the preconfigured env variables for dagit and it works wink for me it seems it is working any guess wink what is happening what should i check

Istvan Darvas · Answer

I think i have a guess what is happening this execution comes from the worker not dagit I am going to check that config too

Istvan Darvas · Answer

celery worker got the right credentials too

Istvan Darvas · Answer

I think I still dont understand the execution modell