S K

    S K

    1 year ago
    Hi all, what kind of permission does the Postgres "prefect_user" in config.toml file needs...I am seeing that the prefect server is starting only if the postgres "prefect_user" is part of rds_superadmin, otherwise getting error "Could not upgrade the Database!". All I am trying to do is to avoid assigning elevated access to postgres "prefect_user" id, because for prefect we are using postgres that is used by our OLTP applications. Also advise what kind of database upgrade happens every time the prefer server is started.
    Chris White

    Chris White

    1 year ago
    Hi SK! Your setup sounds risky to me — Prefect needs the ability to alter the public schema, and every time Server upgrades the database it runs migrations against the tables that Prefect needs. Sometimes these migrations are small, and other times they can be large. Server is built under the assumption of a dedicated database just for Prefect’s use.