I'm curious if there's a demand for an open source alternative to existing solutions like Kasten that can restore your CNPG cluster and automate disaster recovery drills. I previously mentioned something like this in a PostgreSQL community but didn't get much feedback. My vision is to have a system that sends a report with a simple checkbox indicating that your organization can recover from issues. While I see many projects focused on backup, hardly any assure recovery and offer automated DR drills.
2 Answers
Totally agree! But it should ideally integrate well with existing operators. It's great that we can recover databases, but having a user-friendly UI for managing the process would really enhance the experience.
You could definitely set up a job to create a new CNPG cluster from a backup and run some queries to test recovery. However, I've got a bunch of scripts for different tasks already. It makes you wonder: why not just use the right tools instead of managing countless scripts? Plus, upgrading can come with its own challenges.
Related Questions
Can't Load PhpMyadmin On After Server Update
Redirect www to non-www in Apache Conf
How To Check If Your SSL Cert Is SHA 1
Windows TrackPad Gestures