I am noticing a lot of sqlite database locks which is adversely affecting the visual state and reporting of flows, subflows and tasks in the UI. For example. I have a flow with multiple concurrent tasks that run. They do appear to be running however the UI shows that there are 0 tasks running and there is no activity on the graph.
How can I add a postgres server to my prefect instance and migrate from sqlite to the postgres instance while keeping the blocks, variables, deployments and other details in place?
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.