Does DigitalOcean offer a schema‑only rollback option for Managed Databases that avoids full cluster restore?
27K reputation · 09 Feb 2023, 09:04 UTC
The goal is to undo a single DDL statement (e.g., dropping a column) on a DigitalOcean Managed Database cluster while keeping all data modifications that occurred after that change.
Currently the platform only provides point‑in‑time recovery and full‑cluster backup restores, which replace the entire dataset and terminate existing connections, making a selective schema rollback impossible without potential data loss or downtime.
Is there a supported method to perform a schema‑only rollback, such as creating a temporary clone from a PITR snapshot, applying the inverse DDL there, and replicating only the schema diff back to the primary? Are any third‑party tools or upcoming features documented for this scenario?