Amazon’s Relational Database Service (RDS) is a managed relational database service provided by AWS. As such, it’s a perfect solution to store and organize your data in a SQL database in the cloud.
However, you should back up your databases regularly to ensure reliability. And when it comes to backing up your AWS RDS and getting the most from the platform, SimpleBackups is the perfect solution.
This post will show you a step-by-step guide to backing up your RDS PostgreSQL database using SimpleBackups.
Before you get started, you’ll need your RDS connection credentials. These will allow you to enable remote PostgreSQL connections for AWS RDS. You’ll first go to your Databases page on your AWS RDS account.
On this page, you’ll see a list of your database instances.
You can then choose your PostgreSQL database from the list of instances.
Once you’ve clicked on the database instance, a page will open where you’ll find the information for your database.
From here, you’ll need a few pieces of information. First, you’ll need the endpoint and the port of your database. You can get this information under the Connectivity & Security tab.
You’ll also need the database name and username. You can get these under the Configuration tab.
Once you’ve obtained your RDS connection credentials, you can set up your backup in SimpleBackups. We’ll now look at the steps you’ll follow to do this.
The first step is logging into your SimpleBackups account.
You have a few options for creating a PostgreSQL backup.
You can either click on Backups in the menu bar, click Create on the PostgreSQL Backup tile, or click on Database backup in the right menu.
If you click on the Backups option in the menu bar, you’ll be taken to another screen which displays a list of your backups.
To get started, you can then click Create Backup.
No matter which option you choose, you’ll get to a screen where you can configure and create your backup.
On this screen, you should ensure that the Databases option is selected.
The first step in configuring your backup is deciding what server you’d like to use. Here, you have two options:
Depending on your unique requirements and whether you have your own server with enough space, you can then select the appropriate option.
Apart from choosing one of these options, you should also select if your database is publicly available.
When it comes to RDS, you’ll typically decide whether the database is publicly available when you create it on AWS.
Finally, depending on your unique setup, you might also need to whitelist SimpleBackups’ IP addresses. Doing this allows SimpleBackups to schedule and run your database backups.
The next step is to connect SimpleBackups to your database. To do this, there are several steps you’ll need to follow:
As you can see from the screenshot, you can also choose the type of backup you’d like to run.
As you can see from the screenshot, you can also choose the type of backup you’d like to run. For example, stream your backups directly to your storage to save disk space, or perform a PostgreSQL Quick Export that provides an improved dump method.
Once you’ve provided all the details of your database and selected the type of backup you’d like, you can click on Validate Connection.
With your database connection set up, you can now perform the final tasks to create your backup. Firstly, you’ll need to provide a name for your backup. Next, you can schedule your backups based on your requirements.
There are a few options. For instance, you can run your backups on demand. You can also run them daily, weekly, or monthly at specified times. It’s also possible to define a custom backup schedule, which allows you to schedule backup intervals of as little as 1 minute.
At this stage, you should also set your backup’s Retention. This is the number of recent backups that you’ll keep. If you reach this threshold, older backups will automatically be deleted.
The final step in creating an RDS backup is choosing your storage. You can choose if you’d like to use your own remote storage or SimpleBackups’ own storage solution, SimpleStorage.
If you choose to use your own remote storage, you can choose from several options, including Amazon S3, Dropbox, Google Cloud Storage, DigitalOcean Spaces, and more. To add your storage, you’ll click on the Connect storage button.
This will take you to a dialog box where you can provide the credentials for your storage in order to connect it to SimpleBackups. You’ll also need to provide the path where you’d like your backups to be stored.
Once you’ve chosen and configured your storage, you can click on Create Backup.
Make sure you can always recover quickly should disaster strike. You don’t even need your own server! And if you’re looking for more robust solutions, SimpleBackups allows you to back up servers and files, replicate your storage across different storage solutions, and get server and volume snapshots.
To learn more about SimpleBackups and how it can help you, create your first backup today.