Thread
#prefect-server
    m

    Minakshi

    1 year ago
    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

    Dylan

    1 year ago
    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: 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
    m

    Minakshi

    1 year ago
    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

    Dylan

    1 year ago
    I’m not actually sure 🧐
    Let me ask around a bit tomorrow and get back to you
    Looks like you can configure a volume to persist in s3 πŸ‘
    m

    Minakshi

    1 year ago
    Got it. Thanks!
    another question, regarding the configuration of custom DB, i was wondering if i could use MySql or any other DB instead of Postgres?
    Dylan

    Dylan

    1 year ago
    Prefect Server is built to be used with Postgres, I don’t believe you can swap the db
    You already have the best database πŸ˜‰