Hi team Is there a way to specify a custom DB to be used wit

Question

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

Dylan · Answer

Hi < Minakshi> To use a persistent volume which will save state on running flows on prefect server deploy upgrade restart with some exceptions check this out

Dylan · Answer

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>

Minakshi · Answer

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

Dylan · Answer

I m not actually sure face with monocle

Dylan · Answer

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

Dylan · Answer

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

Dylan · Answer

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

Minakshi · Answer

Got it Thanks

Minakshi · Answer

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

Dylan · Answer

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

Dylan · Answer

You already have the best database wink