URGENT: Production data loss recovery – ticket SU-457506

[thaydatdtlx-hub]

URGENT: Production data loss recovery – ticket SU-457506

[thaydatdtlx-hub]

Hi Supabase team,

This is an urgent production data-loss incident.

Support ticket: SU-457506
Project ref: pkzxkvcncipfszeukpwu

We need to recover the database state strictly BEFORE:
2026-08-28 14:03:00 UTC
Preferred target: 2026-08-28 14:02:30 UTC.

We have verified that WAL archiving was enabled and found evidence of a physical backup marker existing before the deletion.

The accidental hard deletion affected production student records and related data. Most importantly, we need the original PostgreSQL TOAST/large values from public.students.photo_data, which contain student profile/ID photos.

Could a Supabase staff member please:

1. Check whether ticket SU-457506 has been escalated.
2. Check whether a retained physical backup + WAL chain exists for a recovery point before 14:03 UTC.
3. If recovery is possible, restore it to a NEW temporary database/project for verification.

PLEASE DO NOT overwrite the current production database.

I am currently on the Free plan and cannot afford a Pro upgrade. Any one-time emergency recovery assistance would be greatly appreciated.

Thank you.

[GaryAustin1]

You will likely need to go Pro to get your 7 daily backups (even from when Free) that everyone has seen is available. You then restore to a new project and pull back the data you want to your existing project if you don't want all data overwritten.

One user has commented this for intermediate access between timestamps but I do not know how it works.

Enabled the PITR add-on.
Restored to 2026-08-20 10:55:00 UTC — the last archived WAL timestamp we had
captured from pg_stat_archiver before the accidental restore.
Verified the result against our application logs.

Not sure if support will do this for you or not as backups are not covered for the Free plan. But it likely would be days for a response.