Automatic backups
A full backup of your database is taken every day and kept for 7 days. The Backups tab lists them with their date and size. The first one appears within a day of creating the database.
Restore a backup
Open a ticket and tell us the database and the date you want. We restore that backup into a new database next to your current one, so nothing you have now is overwritten. You can then check the data and point your app to it, or copy back only what you need.
Your own copies
For copies you keep yourself, for longer or somewhere else, use pg_dump, for example every night from a server:
pg_dump --format=custom "CONNECTION-STRING" -f backup-$(date +%F).dumpPhluit S3 Object Storage is a good place to keep them.
When a database is deleted
Its backups are deleted with it. Take a pg_dump first if you might need the data later.
