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.

Prefect Community

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?

Welcome, <@U048PPT3M5H>! 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 <https://discourse.prefect.io/t/prefect-deployments-faq-pdf/1467|PDF> for details on deployments and <https://github.com/anna-geller/dataflow-ops|this repo>

this might be also good to get started <https://medium.com/the-prefect-blog/scheduled-data-pipelines-in-5-minutes-with-prefect-and-github-actions-39a5e4ab03f4>

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

what feature? what problem are you trying to solve?

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

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

if you instead mean task and flow run results, you can set:
```prefect config set PREFECT_RESULTS_PERSIST_BY_DEFAULT=true```

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

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

You’ll want to use `prefect config set PREFECT_ORION_DATABASE_CONNECTION_URL="postgresql+asyncpg://..."` so that it applies to all your flows

<@U02FDNUGQ3H> Maybe the `export` in that tutorial should be a `prefect config set`?

<@U01CEUST9B5> 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?

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

image.png

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

<@U048PPT3M5H>  <@U01CEUST9B5>  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.

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