Skip to main content
PostgreSQL backup
Last update:

PostgreSQL backup

В cloud databases PostgreSQL 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. В control panels go to Cloud platformDatabases.
  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.