i m a new user i want to save the flows to the database Post

Question

i m a new user i want to save the flows to the database PostgreSQL I added the connection and the prefect tables was added to my database I have a record in table configuration But the flows and the logs not inserted to my PostgreSQL database i don t know what i m missing can someone help me please

Anna Geller · Answer

Welcome < Rabea Yousof> You don t need to store your flows to Postgres we use the concept of storage for that If you run everything locally you don t even have to worry about storage Check out this for details on deployments and this might be also good to get started

Rabea Yousof · Answer

Thank you i need to apply this feature with PostgreSQL to keep the data on my database

Anna Geller · Answer

what feature what problem are you trying to solve

Rabea Yousof · Answer

i m trying to save the the flows and tasks history and logs to PostgreSQL <https docs prefect io concepts database configuring a postgresql database> i applied the all steps but when i run the flow the data not saved to the prefect tables in the DB

Anna Geller · Answer

it happens by default no need to do anything there the history and logs are written to DB

Anna Geller · Answer

if you instead mean task and flow run results you can set ```prefect config set PREFECT RESULTS PERSIST BY DEFAULT=true```

Anna Geller · Answer

this way all results will be by default persisted in your default storage location

Zanie · Answer

It sounds like you re trying to use the Postgres database backend instead of SQLIte Did you resolve this

Zanie · Answer

You ll want to use `prefect config set PREFECT ORION DATABASE CONNECTION URL= postgresql+asyncpg ` so that it applies to all your flows

Zanie · Answer

< terrence> Maybe the `export` in that tutorial should be a `prefect config set`

Rabea Yousof · Answer

< Zanie> Yes i m using Postgres as backend now with the local prefect and it s working very good Can i use Postgres database backend or secondary database with prefect cloud

Zanie · Answer

Prefect Cloud has its own backing database You can use profiles to switch between local cloud if you want but they wont share data

Rabea Yousof · Answer

Hi < Zanie> can you help me with this error I added the connection string and i started the Orion

Matthew Jeffs · Answer

< Rabea Yousof> < Zanie> were you able to get this resolved I recently switched from SQLite to Postgres and got that error I am working to try and troubleshoot now

Zanie · Answer

I think we ll need a full bug report at <https github com PrefectHQ prefect issues new assignees= amp labels=status 3Atriage 2Cbug amp template=1 general bug report yaml> to help with that