Appearance

Vultr ​

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

Vultr offers managed database clusters supporting MySQL, PostgreSQL, and Redis. Connecting a Vultr database to SimpleBackups requires configuring trusted sources, copying your connection credentials, and optionally providing a CA certificate. SimpleBackups also supports automatic discovery through the Vultr API. This guide covers both approaches.

Connecting your database ​

Step 1: Configure IP filtering ​

  1. Log in to your Vultr account and navigate to the databases section under Products.

Vultr products section showing managed databases

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

Vultr trusted sources configuration screen

Step 2: Copy your connection credentials ​

  1. Navigate to the Connection Details section.
  2. Copy the connection details or the full service URI (for example, Copy MySQL URL).
  3. Download the CA Certificate.

Vultr connection details section showing URI and CA certificate download

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 Vultr

Automatic import via DBaaS provider

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

SimpleBackups DBaaS provider selection for Vultr

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

SimpleBackups TLS certificate configuration for Vultr

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.

Vultr backup logs tab

Vultr backup detail view

Vultr 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