Standard tier databases include 7 days of automatic daily backups. The information below will help in the event you need to restore to a prior point.
Restoring a Database Backup
We take automatic backups every day and keeps seven backups available.
First, get your database ID by running:
View what backups you have available by running:
gigalixir pg:backups -d $DATABASE_ID
Find the backup ID you want.
Recover the backup with:
gigalixir pg:backups:restore -d $DATABASE_ID -b $BACKUP_ID
This can take a while. Sometimes over ten minutes. To check the status, run:
Restoring to a Separate Database Instance
If you want to keep your current data, but would like your backup restored to a new database, contact us for help.