I Dropped a Table in Production—Now What?
This title could be clearer and more informative.Try out Clickbait Shieldfor free (5 uses left this month).
When you accidentally drop a table in a multi-terabyte production Postgres database, Neon's instant Point-in-Time Recovery (PITR) lets you restore to the exact moment before the drop in about one second, regardless of database size. Two recovery routes are outlined: (1) keep production running and copy the missing table from a PITR branch — preserving post-incident data — or (2) fully rewind production to the pre-drop state by swapping branches under the same endpoint without changing connection strings. Both approaches leverage Neon's copy-on-write storage model, which avoids the slow snapshot-restore and WAL-replay process required by AWS RDS, where multi-TB restores can take hours.
