UpCloud Managed PostgreSQL Backups

postgresql
upcloud

Backup a UpCloud Managed PostgreSQL to your external storage

UpCloud Managed PostgreSQL Logo

Description

Backup your PostgreSQL in one simple backup.

Your PostgreSQL databases can be backed up to any of our supported S3, AWS S3, DigitalOcean Spaces, Wasaibi, Backblaze B2 and custom S3 endpoints


Easily find your PostgreSQL Database

Scan for database

Using our setup process helper, we can scan your server to find all the database you may wish to backup


Support For Any Host

Our backup Solution works for any PostgreSQL server, whether hosted on your own server or using a managed solution like PostgreSQL or DigitalOcean managed databases


Docs

How to backup Upcloud PostgreSQL - Setup Guide

Step 1

  • Login to your UpCloud account and find your PostgreSQL database under the Database Section

Step 2 Allow Network Connection (optional)

If you're using SnapShooter's Compute Engine for backups you will need to allow access to the PostgreSQL database, If you're using your own servers, you need to make sure your own server has its access to PostgreSQL and SnapShooter can access that server.

Allow Public Access to PostgreSQL
  • Make sure Public Connection is enabled UpCloud Public Databse Connection
Allow Remote IP Access
  • On the same screen look for Allowed IP access
  • Go to the Allow incoming connections using IPv4 CIDR blocks. form
  • In SnapShooter Find the IP's you need Compute ip WhiteList
  • Find the region you need, for example if your storage is US East (N. Virgina) SnapShooter US East IP's
  • Add the IP's to UpCloud Add Ips to allowed ips
  • Press Add

3 - Create a new backup job

  • Login to SnapShooter
  • Go to make new backup job Quick Setup and select UpCloud PostgreSQL
  • Give it name

4 - Choose Server or SnapShooter Compute

Decide if you want to use your own server for the backup or want to use SnapShooter's Compute Engine, and enjoy 2h worth of backups a month (Easily enough to backup a small database daily for free) https://i.imgur.com/2cBAyfh.png

5 - Configure PostgreSQL Backup

  • Provide your username (defaults to upadmin)
  • Provide your password
  • Choose hostname
  • Port should remain 11550 unless changed
  • Database name will depend on what Database you want backed up
  • Flags can be left as default unless you have special requirments
  • Compression level is defaulted at 6 which is mid way, increase if you want small backups, but will take longer

Test and configure Upcloud PostgreSQL backup

6 - Choose Storage

If you used your own server you can use any storage provide you wish.

If you used SnapShooter Compute you can use your own S3 or you can use SnapShooter Storage which comes with 500mb free.

7 - Choose Backup Frequency

Free users can enjoy daily backups, other paid plans will allow more frequent backups

https://i.imgur.com/gup59am.png

Press schedule and finish

8 - Run your first Backup

Press backup now link


Related Backup Recipes