Skip to main content

PostgreSQL TimescaleDB cluster backups

With PostgreSQL TimescaleDB cloud databases, cluster backups are created automatically — you don't have to configure them 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 uploaded. Automatic creation of backups cannot be disabled.

Backup schedule⁠

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

Backup retention period⁠

Backups are stored for 7 days, after that they are deleted.

Backups of deleted clusters are stored for 7 days from the date of backup creation. You can restore a cluster from the backup.

Restore the cluster⁠

You can restore an existing or deleted cluster from backup. Restore is available for 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 the Dashboard, on the top menu, click Products and select Cloud Databases.
  2. Open the Active tab.
  3. From the menu of the cluster, select Restore.
  4. Select how to restore the cluster — from the last available backup or to a specific point in time within the last 7 days.
  5. Click Continue.
  6. You will be redirected to the page for creating a new cluster. If necessary, change the cluster settings — see the Create a cluster instruction for details.
  7. Click Create Cluster.
  8. After the cluster is restored, the node addresses will change — change them in the application that connects to the cluster.