Skip to main content
Backing up PostgreSQL TimescaleDB
Last update:

Backing up PostgreSQL TimescaleDB

In cloud databases PostgreSQL TimescaleDB cluster backup is automatic — you don't need to configure it yourself and keep track of backups.

The WAL-G tool is used to create cluster backups. WAL files are used to perform Point-in-Time Recovery.

Backups are stored in isolation from other users' backups.

Backups cannot be unloaded. Automatic backups cannot be disabled.

Backup schedule⁠

  • Full cluster backups are created once a week.
  • Incremental (delta) backups are created once a day. Such backups contain all changes from the previous backup.
  • WAL files are created every 10 minutes or when a certain amount of changes accumulate.

Retention period for copies⁠

Backups are kept for 7 days, after which they are deleted.

Backups of remote clusters are kept for 7 days from the time the copy is created. From the copy you can cluster recovery.

Restore the cluster⁠

You can restore a cluster from a backup to any point in time in the last 7 days.

When restoring, a new database cluster is created — you can change the name, configuration (with the same or larger disk size), number of nodes, network and DBMS settings. The DBMS type and version cannot be changed.

  1. In control panel go to Cloud platform → Databases.
  2. On the menu. cluster select Restore.
  3. Choose how to restore the cluster — from the last available backup or to a specific point in time within the last 7 days.
  4. You will be redirected to the page for creating a new cluster. If necessary, change the cluster settings (see the instructions for details) Create a cluster) and press Create a cluster.
  5. Once the cluster is rebuilt, the node addresses will change — change them in your application.