Restore deleted records in PostgreSQL

Question

I accidentally deleted all the records from 3 tables in PostgreSQL. How can i restore the data?

You're probably out of luck. I think [Craig Ringer](http://stackoverflow.com/users/398670/craig-ringer) wrote a big answer about this but it might be over on dba.stackexchange.com. — mu is too short, Nov 21 '13 at 06:07
@user236928 Not without serious data recovery expertise, which costs serious money. You told the database to delete the data, so it did. Recovery is only possible if the server hasn't yet overwritten the data. Read http://stackoverflow.com/questions/12472318/can-i-rollback-a-transaction-ive-already-committed-data-loss — Craig Ringer, Nov 21 '13 at 06:25

score 16 · Accepted Answer · edited May 23 '17 at 12:08

16

This is a similar problem as discussed here:

Basically, restore from backup. If you can't, you might be able to recover with pg_dirtyread.

If you don't have backups, stop the whole server, take a disk image of the drive, and contact a $lots data recovery expert.

edited May 23 '17 at 12:08

Community

answered Nov 21 '13 at 06:12

Craig Ringer

1 Answers1