# Exoscale

How to back up Exoscale managed PostgreSQL databases via SimpleBackups.

Exoscale is a European cloud provider offering managed PostgreSQL databases. Connecting your Exoscale PostgreSQL to SimpleBackups requires configuring IP filtering, copying your connection credentials, and optionally supplying a CA certificate for TLS verification. This guide walks you through each step.

## Connecting your database

### Step 1: Configure IP filtering

1. Log in to your Exoscale account and navigate to the databases section.

![Exoscale databases section in the dashboard](https://simplebackups.com/docs/docs-assets/media-helpkit-co/98c068c73c9fd675855c.png)

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

![Exoscale IP filter tab with IP address entry form](https://simplebackups.com/docs/docs-assets/media-helpkit-co/06418178011173cefa5f.png)

### Step 2: Copy your connection credentials

1. Switch to the **Connection Data** tab.
2. Copy the **Service URI**.
3. Download the **CA certificate**.

![Exoscale connection data tab showing Service URI and CA certificate download](https://simplebackups.com/docs/docs-assets/media-helpkit-co/58e7661ea4864064b587.png)

### Step 3: Set up a database backup in SimpleBackups

1. Navigate to creating a new database backup and choose **Serverless**.
2. Select **PostgreSQL** as the database type.
3. Click **Paste connection string** and paste the Service URI.
4. Under **Certificate / TLS**, select **REQUIRED** mode.
5. Paste the CA certificate you downloaded into the designated field.
6. Click **Validate connection** to confirm the settings are correct.

![SimpleBackups PostgreSQL connection form with TLS certificate field](https://simplebackups.com/docs/docs-assets/media-helpkit-co/047adf5253a4e96f6206.png)

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

![Exoscale backup logs tab](https://simplebackups.com/docs/docs-assets/media-helpkit-co/eff5bcc6653d33c880f8.png)

![Exoscale backup detail view](https://simplebackups.com/docs/docs-assets/media-helpkit-co/8f5648c1773e98d204e0.png)

![Exoscale restore tab with download link](https://simplebackups.com/docs/docs-assets/media-helpkit-co/3136b03687468ec47bcc.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.