19913d85-f662-4518-a9a1-7adc1793dfd4.png){kind=small}
one last question for today, I promise. - Now Dagi...
# announcementsi
Istvan Darvas
11/25/2020, 7:29 PMone 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
11/25/2020, 7:29 PMI got this error, when I try to start the pipeline from Dagit's playground
Istvan Darvas
11/25/2020, 7:30 PMwhat should I check? drop/purge DB? and let Dagit repopulate it with its schema ?
Istvan Darvas
11/25/2020, 7:31 PMin local, with local Dagit this is running seamlessly
Istvan Darvas
11/25/2020, 7:33 PMThese are the modules I use in dagit's python env
p
prha
11/25/2020, 7:35 PMThis 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.yamli
Istvan Darvas
11/25/2020, 7:37 PMI 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
11/25/2020, 7:46 PM@prha you are right, thanks, I have to revisit the helm chart, because the credentials are missing from the dagster's config 😉 OMG... tomorrow I am going to fix this, my custom pg_resource got the credential only 😉 thanks again
p
prha
11/25/2020, 8:01 PMoh good! glad you were able to track that down!
i
Istvan Darvas
11/26/2020, 10:21 AM@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
11/26/2020, 10:21 AMthis is the dagster config, totally default
Istvan Darvas
11/26/2020, 10:25 AMhere 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 😉 ... for me it seems it is working...any guess? 😉 what is happening? what should i check?
Istvan Darvas
11/26/2020, 10:30 AMIstvan Darvas
11/26/2020, 10:36 AMI 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
11/26/2020, 10:48 AMcelery worker got the right credentials too
Istvan Darvas
11/26/2020, 10:59 AMI think I still dont understand the execution modell