We recently moved our database cluster from self-hosted to Digital Ocean Managed Postgres. We would like to rollback the entire database to a recent point in time.
The backups are available for up to a week
According to the docs we cannot directly restore the database from the backup:
When you restore from a backup, we create a new copy of your cluster’s primary node. You cannot restore directly into the primary node itself because this creates alternative timelines for the database that introduce unwarranted complexity in a managed service. By restoring into a new primary node, a single linear timeline history is preserved.
When the new cluster is restored, it is a parallel cluster (see image below), there does not seem to be any way to make it assume the connection parameters of the original cluster.
The only way forward we can see is to do a full export from the new parallel cluster and drop the original database and import from command line.
Is there another option here?