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

<@ULVA73B9P> is there any know-how on migrating prefect-server-postgresql data from one Kubernetes cluster to another so my new prefect server can have access to all flow runs and history?

Migrating `prefect-server-postgresql` data from one Kubernetes cluster to another involves several steps to ensure all flow runs and historical data are transferred correctly. Here are the steps, synthesized from the Prefect documentation:

1. **Backup the PostgreSQL Database:**
   - Use `pg_dump` to create a backup of your database.
     ```sh
     pg_dump -U &lt;username&gt; -h &lt;old-cluster-postgres-host&gt; -F c -b -v -f &lt;path-to-backup-file&gt;.backup &lt;database-name&gt;
     ```

2. **Transfer Backup to the New Cluster:**
   - Transfer the backup file to a location accessible by your new PostgreSQL instance. This might involve copying the file over SSH or using a cloud storage service.

3. **Restore the Backup:**
   - Use `pg_restore` to restore the backup in your new database instance.
     ```sh
     pg_restore -U &lt;username&gt; -h &lt;new-cluster-postgres-host&gt; -d &lt;database-name&gt; -v &lt;path-to-backup-file&gt;.backup
     ```

4. **Update Prefect Configuration:**
   - Point your new Prefect server to the new PostgreSQL database by setting the `PREFECT_API_DATABASE_CONNECTION_URL` environment variable.
     ```sh
     prefect config set PREFECT_API_DATABASE_CONNECTION_URL="postgresql+asyncpg://&lt;user&gt;:&lt;password&gt;@&lt;new-host&gt;:&lt;port&gt;/&lt;database&gt;"
     ```

5. **Apply Database Migrations:**
   - Ensure the database is up-to-date with any Prefect schema changes.
     ```sh
     prefect server database upgrade -y
     ```

6. **Start the Prefect Server:**
   - Start your Prefect server to begin using the new database.
     ```sh
     prefect server start
     ```

### Useful Resources
- <https://docs.prefect.io/latest/guides/host/|Prefect Hosting Guide>
- <https://docs.prefect.io/latest/guides/deployment/kubernetes/|Running Flows with Kubernetes>

These steps should help you migrate your `prefect-server-postgresql` data from one Kubernetes cluster to another. If you encounter issues or have specific questions, the Prefect Slack community and GitHub repository can be valuable resources for further assistance.