# 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](https://simplebackups.com/docs/docs-assets/media-helpkit-co/300020ee8f5a9c975dd6.png)

2. Select the database you want to back up.
3. Go to the **Trusted Sources** section.
4. Add the [SimpleBackups IP addresses](https://simplebackups.com/docs/help-tips-and-troubleshooting/connecting-a-server/simplebackups-ip-addresses-firewall) to the allowlist.

![Vultr trusted sources configuration screen](https://simplebackups.com/docs/docs-assets/media-helpkit-co/3503dde00bce24db9a69.png)

### 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](https://simplebackups.com/docs/docs-assets/media-helpkit-co/74aed025b9a2c59b52d9.png)

### 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](https://simplebackups.com/docs/docs-assets/media-helpkit-co/a6b50b702970f529a7d0.png)

**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](https://simplebackups.com/docs/docs-assets/media-helpkit-co/2a1869db542cd75b80a4.png)

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

![SimpleBackups TLS certificate configuration for Vultr](https://simplebackups.com/docs/docs-assets/media-helpkit-co/f5c3c8a7ad50d1e47a4e.png)

### 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](https://simplebackups.com/docs/docs-assets/media-helpkit-co/b7b06546d868ff80d1b9.png)

![Vultr backup detail view](https://simplebackups.com/docs/docs-assets/media-helpkit-co/64ed41eb0adee010280b.png)

![Vultr restore tab with download link](https://simplebackups.com/docs/docs-assets/media-helpkit-co/6d9df21f34922e63ea8f.png)

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
```

**Tip:**
Use the latest version of `pg_restore` to avoid compatibility issues during restore.