The Ultimate Aiven Data Pipeline Backup Guide

SimpleBackups founder

Laurent Lemaire

Co-founder, SimpleBackups

March 29, 2024

Aiven streamlines cloud data infrastructure with a single platform that integrates all your crucial data services on any major cloud.

In this guide, we'll show you how to automate Aiven Postgres backups and store them remotely using SimpleBackups.

Why Aiven Data Pipeline Backup is Crucial

One might think why backup is necessary for my Aiven data pipeline? The answer is simple, backup creates a copy of your physical, logical, and operational data.

Which you can store at any safe place such as Amazon S3. This copy comes into use if the running database gets corrupted.

In this example, We're going to backup the Postgres database in this example Aiven data pipeline.
Aiven Data Pipeline

How to automate Aiven Data Pipeline database Backup

Step 1: Grab your Aiven Postgres connection details

  1. Log in to your Aiven console.
  2. Navigate to the database service you wish to back up.
  3. Click on “Overview” then “Connect” or just on the Dashboard, refer to “Connection Details”
  4. Copy the connection string (make sure you replace the **** by the actual password)
    Aiven Postgres Connection String

Step 2: Whitelist SimpleBackups IP Addresses

Note: if your database is behind a firewall, follow the following steps.

  1. In the Aiven console service overview, scroll down to the Allowed IP Addresses section, click on Change
  2. Add the IP addresses provided by SimpleBackups to the whitelist. This allows SimpleBackups to connect to your database.
    Aiven Postgres Whitelist SimpleBackups IP Addresses

Step 3: Create a New Database Backup on SimpleBackups

  1. Navigate to the "Backups" section and click on "Create Backup."
  2. Select "Database Backup."
  3. You may use your own server to dump the backups, but we recommend the “serverless” option.
    SimpleBackups Create Database Backup

Step 4: Configure your Aiven Postgres Backup

  1. Choose PostgreSQL as the database type.
  2. Click “Paste connection string instead”
  3. Fill in the complete connection string for your Aiven Postgres database (make sure the password is added as well and not the asterisks *)
  4. Click “Validate Connection” to make sure the connection is successful.
    SimpleBackups Configure Aiven Postgres Backup

Step 5: Schedule & Customize your Aiven Postgres Backup

  1. Set a schedule for your backups according to your needs (e.g., daily, weekly).
  2. Customize your backup settings, such as retention policies and storage.

Step 6: Monitor your Aiven Postgres Backup

  1. Review your backup configuration to ensure all details are correct.
  2. Save your backup configuration. SimpleBackups will automatically start the backup process according to your schedule.

By following these steps, you can ensure that your Aiven-managed PostgreSQL database is securely backed up, protecting your data against accidental loss or corruption.

Back to blog

Stop worrying about your backups.
Focus on building amazing things!

Free 7-day trial. No credit card required.

Have a question? Need help getting started?
Get in touch via chat or at [email protected]

Customer support with experts
Security & compliance
Service that you'll love using