Ying Ting Loo
08/13/2024, 5:47 AMMarvin
08/13/2024, 5:47 AMprefect server database upgrade -y
command to apply the migrations to your database. Details here.
2. Set Up Database Connection
- Configure your Prefect profile to point to the PostgreSQL database instance on your new server:
prefect config set PREFECT_API_DATABASE_CONNECTION_URL="<postgresql+asyncpg://username:password@new_host:5432/prefect>"
- Confirm the configuration with:
prefect config view --show-sources
- Start the Prefect server:
prefect server start
- More instructions are available here.
3. Transfer Workspace Data
- Review the impacts and steps necessary to ensure all your data, including users, API keys, and accounts, are correctly transferred or updated. This will involve ensuring access, tracking activity, and any potential resources or costs might change.
For a detailed guide on database migration, refer to the documentation and make sure to check the linked GitHub issues for any intermittent problems or updates.
Links:
- Overview of Database Migrations: https://docs.prefect.io/latest/contributing/overview/
- PostgreSQL Configuration Guide: https://docs.prefect.io/latest/guides/host/
- GitHub Discussion on Migration: https://github.com/PrefectHQ/prefect/issues
If you face any issues during these steps, checking the logs for specific errors and consulting GitHub issues related to your problem might be helpful.