Category: Supabase and databases

Supabase: Restoring backup does not restore recent changes

Read this guide in Polish

Once the database has been recovered, some of the last records are absent.

How to identify the source of the problem

Check the exact timestamp backup and PITR availability for the project and plan.

Compare the result for the authorized and unauthorised user, project name and exact error code.

Repair steps

Select the appropriate recovery point and perform a non-production play test before the decision.

How to Test Solution

The set of records corresponds to the selected time point and the data loss limits are clearly documented.

Security and restrictions

Change permissions and scheme first on test data with backup. Do not put service role in your browser.