Managed database and backups
We are a happy user of the DO Managed Database offering. Nevertheless, backup are still not 100% clear for me. I understand you make WAL backups every 5 mins or so and a full backup every 24 hours. So get that you can do PIT restores, etc.
But, what happens if something “catastrophic” happens to the underlying cluster my database is running on? In other words what’s the worst that can happen to my database if WE ourselves are not causing the database to be destroyed/corrupted/made unavailable. In that case would I still have a backup to restore. Or would I need to have standby nodes active for that database?
Is there any recommendation to have a separate backup process back up my database to an external cloud provider for example? (I guess this is always a good practice, but want to be able to make a proper assessment of the urgency for this).
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×