Today it is possible to accidentally restore backup into live production database. There is a "I confirm" dialog in the UI but it is not fool proof, plus when using terraform provider you still could do yourself harm.

It would be nice to have an option similar to Termination Protection where I could mark a cluster that it should be impossible to restore backup into. If I want to restore backup into existing cluster I would have to turn the restore protection off. Or I could restore into a new cluster.

Another way to do it would be to have backup restores possible only into a new cluster (similar to AWS Backup restores). That way you would never accidentally destroy your live production data by restoring old backup into existing cluster. In order to not break current functionalities this option could be turned on for the project. With the option off you could still restore into the existing cluster. With the option on you have to restore into new cluster.