Think about these numbers for a minute. 22 billion records were exposed as a result of data breaches in 2021 and this number is expected to increase. Also, a data breach can cost a business, on average, about $1.59 million. What this, ultimately, means is that, these days, it’s critical that you protect your business’s most valuable data considering the increase in cyberattacks and other security risks. To do this, you’ll typically need a data recovery strategy. As part of this strategy, you’ll likely need to perform regular backups of your databases.
A simple way to ensure that your data is backed up regularly is by using DigitalOcean’s Managed Database solution. However, despite its advantages, it does come with some drawbacks. For instance, while these backups are automatic when using the solution, you’ll only get backups for seven days. And you can only store your backups in DigitalOcean’s data centers. Both these can lead to significant problems should a catastrophe happen.
In this post, we’ll look at a simpler solution for backing up your DigitalOcean PostgreSQL backups.
Let’s first look at how you’ll create your database backups on the DigitalOcean platform. Luckily, you don’t have to do much; free, automatic backups are included in the managed backup solution. So, to create your backup, you simply need to create a database.
Here are the steps you’ll follow to create a new PostgreSQL managed database:
DigitalOcean’s Managed Databases automatically handle data recovery due to hardware and software failures. It does this by replacing degraded nodes with new ones that resume where the previous ones failed. However, you can also manually restore PostgreSQL database backups.
To do this, you’ll:
DigitalOcean’s Managed Database solution eliminates some of the headaches in managing your database backups, but you should be aware of the cons.
For instance, your backups will be stored on DigitalOcean’s servers. What happens when there’s a complete outage?
DigitalOcean only stores your backups for 7 days. If you’d like to restore backups older than this, this could become an issue.
Fortunately, SimpleBackups offers a solution to these challenges. It allows you to:
Let’s look at how you would set up your backups on SimpleBackups!
To set up your database backup, log into your SimpleBackups account.
On your dashboard, you’ll click on PostgreSQL Backup or Database backup.
You can also click on Backups in the main menu at the top of the page. This will take you to the page which lists all your backups. Here, click on Create Backup.
No matter what option you use, you’ll be taken to the Create Backup page, where you can configure your backup.
To start, select Databases under ‘What do you want to create a backup for?’
Next, you’ll choose the server you want to use to run the backup. You have two options – Serverless or Own Server.
In this example, we’ll use Own Server, which allows you to run the backup on your own infrastructure.
SimpleBackups also allows you to store the backups locally, off-site, or on mounted volumes.
When choosing this option, you’ll also need to choose a server from the drop-down list. If no servers are available, you’ll need to connect one first.
You’ll now choose the database you’d like to back up. Because it’s a DigitalOcean Managed Database, you’ll need to activate the Import managed database (DbaaS) option.
Before you can choose your database, you’ll first need to connect SimpleBackups to your DigitalOcean account. To do this, click on Connect Provider. In the popup window that opens, choose DigitalOcean as your provider, give the account a name, and then click Connect DigitalOcean. Then, follow the prompts to connect your account.
Once your accounts are connected, you can choose your database without entering any further information. Also, choose the type of backup you’d like by checking the appropriate boxes.
Once you’ve configured your backup, you’ll finalize the backup by providing a name. Apart from this, also:
Finally, you can choose the storage option you’d like to use for your backups. Here, you have numerous options, from local storage to remote storage like Google Drive, Dropbox, Amazon S3, and others.
You can also opt for SimpleStorage, SimpleBackups’ own managed storage solution for your backups.
If you choose:
Finally, click on Create Backup to create your backup.
Should you need to restore your backup for any reason, simply choose it from your list of backups to go to the backup’s Overview page. Click on Logs, find the version you’d like to restore, and click on the ‘i’ next to the entry. On the dialog box that opens, find the command you can run to restore your backup.
Isn’t it time you protected your databases with regular, consistent backups? If it is, then SimpleBackups is worth a look. It helps you manage your backups, no matter what the platform, all in one place. As a bonus, you can get started for free. So, create your first backup today!
PostgreSQL, renowned for its robustness and flexibility, is a widely-used open-source database management system. One of its strengths lies…
Server-Side Encryption with Customer-Provided Keys (SSE-C) offers a secure method to store sensitive data in cloud storage services like…
Every savvy computer user knows a data backup is like insurance. You don’t really think about it until you end up needing it. This is no…
Free 7-day trial. No credit card required.
Have a question? Need help getting started?
Get in touch via chat or at [email protected]