Backing up and restoring
BigAnimal backs up the data in your PostgreSQL clusters. Depending on the cloud your cluster is deployed on, BigAnimal uses either of the following cloud object storage solutions:
|Cloud||Object storage solution|
|AWS||Amazon S3 (standard tier)|
|Azure||Azure Blob Storage (in the "hot" access tier with geo-zone-redundant storage (GZRS))|
Backups in AWS do not currently support cross-regional replication.
PostgreSQL clusters in BigAnimal are continuously backed up through a combination of base backups and transaction log (WAL) archiving. When a new cluster is created, an initial "base" backup is taken. After that, every time a WAL file is closed, which is, by default, up to every 5 minutes, it is automatically uploaded to the cloud object storage solution. Your organization is responsible for the charges associated with the cloud object storage solution.
You can change the retention period on the Backups tab when you create or edit your cluster.
If a restore is necessary—for example, in case of an accidental
DROP TABLE statement—you can restore clusters to any point within the backup retention period.
Cluster restores aren't performed "in-place" on an existing cluster. Instead, a new cluster is created and initialized with data from the backup archive. Restores must replay the transaction logs between the most recent full database backup and the target restore point. Thus restore times (that is, RTO) are dependent on the write activity in the source cluster.
BigAnimal retains backups for 30 days by default. You can restore backups into a new cluster in any region supported by BigAnimal.
The restore operation is available for any cluster that has at least one available backup. For newly created clusters, the initial backup becomes available a few minutes after the new cluster is fully operational.
- Select the cluster you want to restore on the Clusters page in the BigAnimal portal.
- From Quick Actions, select Restore.
- On the Restore Cluster page:
- Fill in the required fields.
- In the Source section, in the Point in Time Restore field, select Now on the calendar to restore to the last possible recovery point. Or, choose a timestamp to restore further back in time.
- Review your selections in Cluster Summary and select Restore Cluster to begin the restore process.
- The new cluster is now available on the Clusters page.