All Categories
Database Backup
Exoscale PostgreSQL

Exoscale PostgreSQL

How to backup Managed Exoscale PostgreSQL databases via SimpleBackups

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

Prerequisites

  • A SimpleBackups account.
  • Access to your Exoscale Postgres service database
  • Network access from SimpleBackups to your Exoscale PostgreSQL database.
 
  1. Log in to Your Exoscale Account:
      • Navigate to the databases section in your Exoscale dashboard.
          • Notion image
  1. Configure IP Filtering:
      • Select the database you want to backup.
      • Go to the "IP Filter" tab.
      • Add SimpleBackups IP addresses to the whitelist:
        • 34.227.212.80
        • 3.83.70.104
        • 65.108.217.1
        • 95.217.244.243
        • 3.66.2.188
        • 45.55.63.67
          • Notion image
  1. Copy Connection Data:
      • Switch to the "Connection Data" tab.
      • Copy the Service URI.
      • Download the CA certificate.
      Notion image
  1. Set Up Backup in SimpleBackups:
      • Log in to your SimpleBackups account or create a new one if needed.
      • Navigate to creating a new backup and select "PostgresDatabase."
      • Choose "Serverless" and then select "Paste Connection string."
      • Paste the Service URI in the connection string field.
      • Under "Certificate / TLS," select "REQUIRED" mode.
      • Paste the downloaded CA certificate in the designated field.
      Notion image
  1. Validate and Activate Backup:
      • Click on "validate connection" to ensure all settings are correct and the connection can be established.
      • Once validated, finalize any additional backup settings (like scheduling) and activate the backup.

This process ensures that your Exoscale Managed PostgreSQL database is securely backed up using SimpleBackups, providing an additional layer of data protection.

Restoring backups

In order to restore your backup, Go to your backup page, then navigate into logs.

Notion image

Click on the “i” button on the backup that’s on the point of time you’d like to restore to.

Notion image

Click on the Restore tab, then generate a new download link, and copy it.

Notion image

Run the following command

wget -O - "PasteTheSignedDownloadLinkHereBetweenTheQuotes" | gunzip -c > decrypted-backup.pgsql

Then, run the pg_restore command to restore your database like so:

pg_restore -d "your_db_uri" ./decrypted-backup.pgsql
💡
Make sure that you have pg_restore updated to the latest version to avoid facing restore issues.
Did this answer your question?
😞
😐
🤩

Last updated on May 13, 2024

Heroku PostgreSQL Vultr Database