Scalingo Database

Creating Scalingo Database backup (Automatic)

1. Obtain Scalingo API Credentials

1. Go to https://dashboard.scalingo.com/account/tokens.

2. Click “Add”.

3. Copy the generated Key to somewhere safe.

2. Get the Application Name

1. From the dashboard navigate to “Apps”.

2. Choose the app where the database exists.

3. Copy the “Application Name”.

3. Create Scalingo Provider on SimpleBackups

1. Afterwards, create a new provider on SimpleBackups with your Scalingo API Key by going to the database backup page and click add on the “Connect your DBaaS Provider” section as shown.

2. Select Scalingo from the Provider dropdown list, enter a name for your Scalingo account, then paste the Token and the Application Name we obtained in the previous step and click save provider.





• Select your provider, the database you want to backup and click on “load”

4 . 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.

Creating Scalingo Database backup (Manual)

• Scalingo MySQL database.

• Scalingo PostgreSQL database.

Prerequisites

• A SimpleBackups account.

• Access to your Scalingo database

• Network access from SimpleBackups to your Scalingo database.

1. Log in to Your Scalingo Account:

• Open the Application contains the database you want to backup.

• Navigate to the Addons section in the application.

2. Configure IP Filtering:

• Select the database you want to backup and click on Dashboard.

• Navigate to “TLS/Internet access” section and enable both “Force connections using TLS” and “Internet Accessibility”.

• Navigate to “Database TLS Certificates” section and download the certificates.

3. Copy Connection Data:

• Navigate to “Database Access” section and copy the connection string.

• Also you can get the complete “connection string” with “user” and “password” from the main application page.
• On main application page navigate to “Environment” tab and copy the connection string for your database

4. Set Up Backup in SimpleBackups:

• Log in to your SimpleBackups account or create a new one if needed.

• Navigate to creating a new database backup.

• Choose "Serverless".

5. Fill the connection details:

• Choose the Database “Type”.

• You can either fill the form with connection details or select "Paste Connection string" and paste the service URI.

6. 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.

Restoring backups

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

pg_restore -d "your_db_uri" ./decrypted-backup.pgsql

Scalingo MySQL Database backup

Scalingo PostgreSQL Database backup