Appearance

Scalingo ​

How to back up and restore Scalingo managed databases via SimpleBackups.

Scalingo is a European PaaS platform that provides managed add-on databases for MySQL and PostgreSQL. Connecting a Scalingo database to SimpleBackups requires generating an API token and enabling internet access on the database. This guide covers both the automatic API-based setup and the manual connection string approach.

Automatic setup ​

In this section, you will generate a Scalingo API token and connect your Scalingo application to SimpleBackups so that databases are discovered automatically.

Step 1: Obtain Scalingo API credentials ​

  1. Go to https://dashboard.scalingo.com/account/tokens.
  2. Click Add.
  3. Copy the generated key to a safe location.

Scalingo API tokens page with Add button

Step 2: Get the application name ​

  1. From the dashboard, navigate to Apps.
  2. Choose the app that contains the database you want to back up.
  3. Copy the Application Name.

Scalingo apps list screen

Scalingo application overview showing the application name

Step 3: Create a Scalingo provider in SimpleBackups ​

  1. Go to the database backup page and click Add in the Connect your DBaaS Provider section.
  2. Select Scalingo from the Provider dropdown, enter a name for your Scalingo account, paste the token and application name, then click Save provider.

SimpleBackups provider connection form for Scalingo

SimpleBackups Scalingo provider saved confirmation

  1. Select your provider and the database you want to back up, then click Load.

Step 4: Validate and activate ​

Click Validate connection to confirm that SimpleBackups can reach your database. Once validated, configure your schedule and activate the backup.

Manual setup ​

Use this approach if you prefer to supply connection credentials directly rather than through the Scalingo API.

Step 1: Open your Scalingo database ​

  1. Open the application that contains the database you want to back up.
  2. Navigate to the Addons section.

Scalingo application addons section

Scalingo addon list showing the database

Step 2: Enable internet access and download certificates ​

  1. Select the database you want to back up and click Dashboard.
  2. Navigate to the TLS/Internet access section and enable both Force connections using TLS and Internet Accessibility.
  3. Navigate to the Database TLS Certificates section and download the certificates.

Scalingo database dashboard showing TLS and internet access settings

Step 3: Copy your connection string ​

  1. Navigate to the Database Access section and copy the connection string.

Scalingo database access section showing connection string

  1. You can also find the full connection string including the username and password from the main application page. Navigate to the Environment tab and copy the connection string for your database.

Scalingo application environment tab with database connection string

Step 4: Set up a backup in SimpleBackups ​

  1. Navigate to creating a new database backup and choose Serverless.
  2. Select the database Type and fill in the connection details, or click Paste connection string and enter the full service URI.

SimpleBackups database connection form with connection string for Scalingo

Step 5: Validate and activate ​

Click Validate connection to confirm that SimpleBackups can reach your database. Once validated, configure your schedule and activate the backup.

Restoring a backup ​

To restore a backup, navigate to your backup page and open the Logs tab. Click the detail icon on the backup you want to restore from, then open the Restore tab. Generate a download link and copy it.

Scalingo backup logs tab

Scalingo backup detail view

Scalingo restore tab with download link

Run the following command to download and decompress your backup (replace the URL with your signed download link):

bash
wget -O - "<signed-download-url>" | gunzip -c > backup.pgsql

Then restore using pg_restore, replacing <your-database-uri> with your full database connection string:

bash
pg_restore -d "<your-database-uri>" ./backup.pgsql