Scalingo Database
How to back up and restore Scalingo Managed databases via SimpleBackups
Creating backups
To create backups for Scalingo database using SimpleBackups, follow these steps. The process is designed to be straightforward, ensuring that your Scalingo database is securely backed up.
You can create a Backup for any Scalingo Database type:
- Scalingo MySQL database.
- Scalingo PostgreSQL database.
Prerequisites
- A SimpleBackups account.
- Access to your Scalingo database
- Network access from SimpleBackups to your Scalingo database.
Step 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.
Step 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.
Step 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
Step 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".
Step 5: Fill the connection details:
- Manual form fill:
- Choose the Database “Type”.
- You can either fill the form with connection details or select "Paste Connection string" and paste the service URI.
- Auto form fill:
- Click on “Connect your DBaaS Provider”.
- Choose an Scalingo provider.
- Select a managed database.
- Click on “Load”.
- Under "Certificate / TLS," select "REQUIRED" mode.
- Paste the downloaded CA certificate in the designated field.
Step 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.
This process ensures that your Scalingo 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.
Click on the “i” button on the backup that’s on the point of time you’d like to restore to.
Click on the Restore tab, then generate a new download link, and copy it.
Based on your database type run these commands (for example: PostgreSQL):
wget -O - "PasteTheSignedDownloadLinkHereBetweenTheQuotes" | gunzip -c > decrypted-backup.pgsqlThen, run the pg_restore command to restore your database like so:
pg_restore -d "your_db_uri" ./decrypted-backup.pgsqlpg_restore updated to the latest version to avoid facing restore issues. Scalingo MySQL Database backup
SimpleBackups supports Scalingo MySQL Database backup.
Scalingo PostgreSQL Database backup
SimpleBackups supports Scalingo PostgreSQL Database backup.
Last updated on July 5, 2024