Appearance

OVH ​

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

OVH offers managed database clusters under its Public Cloud offering, supporting MySQL, PostgreSQL, Redis, and MongoDB. Connecting an OVH database to SimpleBackups requires configuring authorized IPs, copying your connection credentials, and optionally providing a CA certificate. SimpleBackups also supports automatic discovery through the OVH API. This guide covers both approaches.

Connecting your database ​

Step 1: Configure IP filtering ​

  1. Log in to your OVH account and navigate to the databases section under Public Cloud.

OVH Public Cloud databases section

  1. Select the database you want to back up.
  2. Go to the Authorised IPs section.
  3. Add the SimpleBackups IP addresses to the allowlist.

OVH authorised IPs section

OVH IP address entry form

Step 2: Copy your connection credentials ​

  1. Navigate to the Login Information section.
  2. Copy the connection details or the full service URI.
  3. Download the CA Certificate.
  4. From the Users tab, retrieve user details or reset the user password if needed.

OVH login information section showing connection details

OVH users tab

Step 3: Set up a database backup in SimpleBackups ​

Navigate to creating a new database backup and choose Serverless. You can connect using either manual form fill or automatic import:

Manual connection

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 manual fields for OVH

Automatic import via DBaaS provider

  1. Click Connect your DBaaS Provider.
  2. Choose an OVH provider.
  3. Select the managed database you want to back up.
  4. Click Validate.

SimpleBackups DBaaS provider selection for OVH

For both methods, under Certificate / TLS, select REQUIRED mode and paste the CA certificate you downloaded.

SimpleBackups TLS certificate configuration for OVH

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.

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.

OVH backup logs tab

OVH backup detail view

OVH 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