Best Way to Revert to Original Postgres Cluster After Recovery?

Hello everyone,

In the event of a database crash, the recommended approach on Fly.io is to create a new Postgres cluster from the latest snapshot or backup and update the DATABASE_URL secret in our main app to point to the new cluster.

This works well for restoring service quickly, but we have multiple apps (e.g., BI tools) that also depend on the database connection. Updating their connection strings manually every time is not ideal—we would prefer to keep a consistent database hostname.

What would be the best way to revert back to the original Postgres cluster name after recovery?

One possible approach might be:
1. Delete the original (failed) Postgres cluster.
2. Create a new Postgres cluster using the original name from the restored backup.
3. Reattach the new cluster to the application.
4. Assign the original public IP (or ensure the hostname remains unchanged).

Would this be the best method, or is there a more efficient way to handle this?

Thanks in advance for any insights!