PostgreSQL backup
In cloud databases PostgreSQL cluster backups are 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 copies contain all changes from a past 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. You can restore cluster from a copy.
Restore the cluster
You can restore a cluster from a backup to any point in time in the last 7 days.
The restore creates a new database cluster — 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.
- If the cluster is not deleted
- If the cluster is deleted
- In Control Panel, go to Cloud Platform → Databases.
- From the () menu of the cluster, select Restore.
- Choose how to restore the cluster — from the last available backup or to a specific point in time within the last 7 days.
- You will be redirected to the page for creating a new cluster. If necessary, change the cluster settings (see the Create Cluster instructions for details) and click Create Cluster.
- Once the cluster is rebuilt, the node addresses will change — change them in your application.
- In Control Panel, go to Cloud Platform → Databases.
- Click Create Cluster.
- Select the pool where the remote cluster was located.
- Check the Restore cluster from backup checkbox.
- Select the source cluster.
- Choose how to restore the cluster — from the last available backup or to a specific point in time within the last 7 days.
- Press Continue.
- Select the rest of the cluster settings — see the Create Cluster instructions for details.
- Click Create Cluster.
- Once the cluster is rebuilt, the node addresses will change — change them in your application.
Cost
Backup storage is paid under cloud platform payment model.
The cost is listed on website.