Aiven PostgreSQL

How to backup Managed Aiven PostgreSQL databases via SimpleBackups

To create backups for a Aiven-managed PostgreSQL database using SimpleBackups, follow these steps. The process is designed to be straightforward, ensuring that your Aiven PostgreSQL database is securely backed up.

Prerequisites

  • A SimpleBackups account.
  • Access to your Aiven Postgres service database and permission to create new users/roles.
  • Network access from SimpleBackups to your Aiven PostgreSQL database.

Step 1: Create a Backup User in Aiven

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

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
  1. Add the IP addresses provided by SimpleBackups to the whitelist. This allows SimpleBackups to connect to your database.
    1. Notion image

Step 3: Create a New Database Backup on SimpleBackups

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

Step 4: Configure Database Backup Settings

  1. Choose PostgreSQL as the database type.
  1. Click “Paste connection string instead”
  1. Fill in the complete connection string for your Aiven Postgres database (make sure the password is added as well and not the asterisks *****)
  1. Click “Validate Connection”
    1. Notion image

Step 5: Schedule and Customize Your Backup

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

Step 6: Save and Activate the Backup

  1. Review your backup configuration to ensure all details are correct.
  1. 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.

Did this answer your question?
😞
😐
🤩

Last updated on May 6, 2024