Supabase: Restoring backup does not restore recent changes
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.