Recommended
Backups
Every night the app copies every record and every file to a storage bucket you own. Supabase keeps its own daily backups for 7 days; this one is yours, outside Supabase, and kept forever.
- What it is
- Cloud storage for files. Cloudflare R2 is used here; AWS S3, Backblaze B2 and Wasabi work the same way.
- Cost
- At the time of writing R2 gives 10 GB free each month, then about 1.5 cents per GB a month, with no charge to download. A small rental company's backup is usually a few GB.
- Time
- 10 minutes.
- You will write down
- The endpoint address, the bucket name, an access key ID and a secret access key.
Part A: the bucket
- Open dash.cloudflare.com and sign up or sign in with the company email.
- Left menu: R2 Object Storage. The first time, Cloudflare asks for a card to turn R2 on; nothing is charged inside the free amount.
- Press Create bucket. Name it, for example
yourcompany-crm-backup(lowercase letters, numbers and dashes). Location: Automatic. Press Create bucket. - Open the bucket's Settings. Under S3 API copy the address. It looks like
https://<account id>.r2.cloudflarestorage.com/yourcompany-crm-backup. The endpoint is that address without the bucket name at the end.
Part B: the token
- Back on the R2 page, press Manage R2 API Tokens (or API, then Manage API tokens), then Create API token.
- Name it
CRM backup. Permissions: Object Read & Write. Under Specify bucket pick only the backup bucket. Leave the time to live as Forever. Press Create API Token. - Copy the Access Key ID and the Secret Access Key. The secret is shown once; if you lose it, make a new token.
Part C: in the app
- Open Settings, Tools, Backups.
- Paste the five values: Endpoint, Bucket name, Region (type
autofor R2), Access key ID and Secret access key. Save each. - Press Test the key. The app writes a small file to the bucket and deletes it again; it should say it can reach the bucket.
- Press Back up now for the first copy, or leave it for tonight. After two in the morning (your company's time) it runs by itself every night.
What is kept
- db/ holds one folder per night: every table, a list of the logins, and a manifest. Nightly folders are kept 30 days; the folder from the first of each month is kept forever.
- files/ holds every photo, document and file, copied once. A file deleted in the app stays in the backup.
- Service keys you pasted under Connections are not in the backup; after a restore you paste them again.
Done when: Test the key says it can reach the bucket, and the Backups card shows a finished backup with its date and size.