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

Hi team, Is there a way to specify a custom DB to be used with prefect server instead of the default postgres db? Is the prefect server able to save state of running flows on prefect server deploy/upgrades and restarts?

Hi <@U0193D2NES2>!

To use a persistent volume (which will save state on running flows on prefect server deploy/upgrade/restart with some exceptions) , check this out: <https://docs.prefect.io/orchestration/Server/deploy-local.html#database-persistence-and-migrations>

To use a fully managed postgres instance, you can update the connection info by overwriting the values in the Prefect Server config: <https://github.com/PrefectHQ/server/blob/master/src/prefect_server/config.toml>

Thanks Dylan, if i were to use a persistent volume as specified in option 1, can i store this volume in s3 or something similar so that it can be reused? What is the recommendation in that case?

I’m not actually sure :face_with_monocle:

Let me ask around a bit tomorrow and get back to you

I found this: <https://blog.vizuri.com/practical-persistent-cloud-storage-for-docker-in-aws-using-rexray-pt-1>

Looks like you can configure a volume to persist in s3 :thumbsup:

another question, regarding the configuration of custom DB, i was wondering if i could use MySql or any other DB instead of Postgres?

Prefect Server is built to be used with Postgres, I don’t believe you can swap the db

You already have the best database :wink: