Hi All sorry to bug about an issue with an on prem setup aga

Question

Hi All sorry to bug about an issue with an on prem setup again but we re updated an on prem prefect server to use postgres updated the PREFECT ORION DATABASE CONNECTION URL we re on 2 7 12 on a different profile to the correct url but Prefect is using the sqlite database instead even when we use the profile using a call to start the server with the p profile name flag Are there any other flags to set I can t see what the setting is on the server as it s blanked out which makes sense as it could have passwords in it

Nathan Low · Answer

Is there anything I can do with this Our sqlite db on prod is at 12GB and I m definitely seeing issues with getting the prefect server to work when the database gets to this size

Zanie · Answer

Can you try setting the profile with `PREFECT PROFILE` instead

Zanie · Answer

We might not properly pass the current profile to sub commands with the ` p` flag

Nathan Low · Answer

Ok I ll give that a shot thanks

Nathan Low · Answer

I ve tried updating the default profile but that didn t seem to take either

Zanie · Answer

Really via `prefect profile use `

Zanie · Answer

That d be pretty weird We also changed the setting name to `PREFECT API DATABASE CONNECTION URL` the old one should still work but you may want to just use the new one to avoid any complications

Nathan Low · Answer

Yeah locally I ve noticed the prefect config set doesn t actually update the project toml files

Zanie · Answer

It updates a profiles file at ~ prefect

Nathan Low · Answer

in linux sure but in windows it updates C users user that is running the process prefect but it s not doing that

Zanie · Answer

~ being whatever your home directory is yes smile

Zanie · Answer

It s not updating the profiles file but it doesn t error

Nathan Low · Answer

Then when you set PREFECT HOME it puts the toml file there but doesn t seem to update it through the command line

Nathan Low · Answer

yeah no error just config updated successfully or something like that

Zanie · Answer

You can t change the home directory that way

Zanie · Answer

The home directory needs to be consistent because that s how we find the profiles to read

Nathan Low · Answer

not through prefect config set PREFECT HOME

Zanie · Answer

Yeah you shouldn t do that

Nathan Low · Answer

Ok what should we do

Zanie · Answer

We can add a guard for it

Zanie · Answer

If you want to change the home directory use an environment variable

Nathan Low · Answer

Ok gotcha

Zanie · Answer

Changing the home directory changes the profile lookup path

Zanie · Answer

So if you change the home directory in a profile we ll never find it smile

Zanie · Answer

Nathan Low · Answer

Cool thanks

Nathan Low · Answer

Yeah that got us for like a month figuring that file update thing out just updated it by hand to get it working

Nathan Low · Answer

Ok I ve set the settings as environment variables now I get permission denied on the folder set in the environment variable I ve opened it up to Everyone so I m confused

Nathan Low · Answer

Seems to mostly be dependant on the PREFECT PROFILES PATH environment variab le

Nathan Low · Answer

After changing the PREFECT HOME environment variable and creating a new postgresql profile with prefect profile create test and using prefect set then prefect profile use postgresql before running prefect p postgresql orion start host 0 0 0 0 it is using the postgresql db thanks a bunch

Nathan Low · Answer

I am not entirely sure where the profile toml file is being stored at the moment I think it would where I set PREFECT HOME to be C PrefectServer Orion but didn t see the date modified to be updated on that file in that folder or in ~ prefect C Users svc prefect d prefect

Nathan Low · Answer

And it seems like there s a read timeout when trying to read the ssl certs file to connect to postgresql