AnySites

// DATABASES

Database Backups

What's provided today and how to protect your own data in the meantime.

The Backup & Restore page (under Database) can download a full pg_dump of your database on demand, and restore one back. There is no automated or scheduled backup yet — it only runs when you click the button, so it's on you to do it regularly, especially before a risky migration or bulk edit.

Restore runs pg_restore --clean, which drops and recreates everything in the backup file — it replaces the database's current contents entirely, it doesn't merge. Download a fresh backup of the current state first if you might want it back.

Until scheduled backups ship, treat manual exports as your primary protection, same as you would with any self-managed Postgres instance:

  • Download a backup before any risky change, and periodically otherwise — e.g. from a CI job or external scheduler hitting the API, storing the file outside AnySites.
  • Test the restore path before you need it — a backup you've never restored from isn't a verified backup.

Related documentation