Category: Uncategorized
-

How to Backup a Supabase Database with pg_dump
If you use Supabase for a production application, keeping an independent copy of your database can be a useful part of your backup strategy. Because every Supabase project uses PostgreSQL, you can create a logical database backup using PostgreSQL’s standard pg_dump utility. In this guide, we’ll explain how pg_dump works with Supabase, how to create…
-

Supabase PITR vs Daily Backups: Which Backup Option Should You Use?
If you’re running a production database on Supabase, you may eventually face an important question: Are Supabase daily backups enough, or should you enable Point-in-Time Recovery (PITR)? Both options help you recover from database problems, but they solve slightly different recovery needs. Daily backups give you periodic recovery points. PITR gives you much more precise…
-

How to Recover a Supabase Project Paused for More Than 1 Year
You open Supabase after months away from an old project and see that it is paused. Normally, that is easy to fix: click Resume project. But if the project has been paused for more than a year, Supabase no longer allows the normal one-click restore through Studio. The good news is that this does not…
-

How to Automate Supabase Backups with GitHub Actions
Backing up your Supabase database manually works until the day you forget to do it. If you already keep your project on GitHub, GitHub Actions provides a convenient way to automate Supabase backups on a schedule. A workflow can connect to your database, run the Supabase CLI, create SQL dump files, and store the resulting…
-

How to Restore a Supabase Backup to a New Project
To restore a Supabase backup to a new project, first identify the backup type. Paid projects with physical backups or Point-in-Time Recovery can use Supabase’s Restore to a New Project dashboard feature. For a downloadable .sql, .sql.gz, .dump, or .backup file, create a new Supabase project, enable required extensions, obtain its database connection string, and…
-

Supabase PITR Pricing Explained: Is 7, 14, or 28 Days Worth It?
Supabase Point-in-Time Recovery costs approximately $100 per month for 7 days, $200 for 14 days, or $400 for 28 days of retention, per project. However, that add-on price is not the complete bill. PITR is available only on paid plans, requires at least a Small compute instance, and is billed separately for every project where…
-

Does Supabase pg_dump Count as Egress? Backup Costs Explained
Yes. When pg_dump runs on a machine outside Supabase and downloads data from your hosted Postgres database, the transferred data counts toward your Supabase egress usage. Supabase defines database egress as data sent from the database to a client. PostgreSQL describes pg_dump as a client application that can connect from a remote host. Put those…
-

Supabase Daily Backups Changed in 2026: What Developers Should Know
Supabase quietly made an important improvement to its daily backup system in August 2026. A scheduling issue could occasionally cause projects due for a daily backup within a particular 10-minute window to miss that backup. Supabase fixed the problem on August 12, 2026, adding retry behavior and changing how backup eligibility is checked. For developers…
-

Supabase Backup Retention: How Long Are Backups Kept?
How long does Supabase keep your database backups? As of 2026, Supabase’s standard daily backup retention depends on your plan: Supabase Plan Automatic Daily Backups Backup History Free No standard daily backup history — Pro Yes 7 days Team Yes 14 days Enterprise Yes Up to 30 days Supabase automatically provides daily backups for Pro,…
-

Can You Recover a Deleted Supabase Project? What Happens to Your Backups
If you accidentally deleted a Supabase project, the answer is unfortunately straightforward: A deleted Supabase project cannot be recovered. Supabase states that project deletion is permanent and irreversible. When a project is deleted, its database, Storage objects, backups, authentication data, configuration, API credentials, and other project resources are permanently removed. This also means you cannot…