Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Restore deleted records in PostgreSQL

Tags:

sql

database

postgresql

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

like image 409
v0ld3m0rt Avatar asked Nov 21 '13 05:11

v0ld3m0rt

People also ask

How do I undo a delete in PostgreSQL?

PostgreSQL ROLLBACK command is used to undo the changes done in transactions.

How do I undo in PostgreSQL?

The ROLLBACK command is the transactional command used to undo transactions that have not already been saved to the database. The ROLLBACK command can only be used to undo transactions since the last COMMIT or ROLLBACK command was issued.

What is Pg_restore in Postgres?

pg_restore is a utility for restoring a PostgreSQL database from an archive created by pg_dump in one of the non-plain-text formats. It will issue the commands necessary to reconstruct the database to the state it was in at the time it was saved.

1 Answers

This is a similar problem as discussed here:

Can I rollback a transaction I've already committed? (data loss)

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.

like image 181
Craig Ringer Avatar answered Sep 21 '22 16:09

Craig Ringer
Sign in to Comment

Related questions

Remove duplicate fields from a temp table that has no primary key [duplicate]
Retrieving timestamp of MySQL row creation from meta data?
How to create a table inside of a procedure in Oracle?
equivalent of PostgreSQL type "timestamp without time zone" in SQL Server
SQL one to many with inner join
Oracle SQL execution plan changes due to SYS_OP_C2C internal conversion
Counting how many times a boolean value changes in SQL Server
sql select group by a having count(1) > 1 equivalent in python pandas?
How do I use transaction with oracle SQL?
Getting the First and Last Row Using ROW_NUMBER and PARTITION BY
sp_send_dbmail embed mhtml file in body
Calculate loads and avoiding cursors
Using django how can I combine two queries from separate models into one query?
Difference between creating Guid keys in C# vs. the DB
SQL - When would an empty OVER clause be used?
Data Modeling: Is it always necessary to use an intersection table?
is it a good idea to handle deadlock retry from stored procedure catch block
Oracle: Using a database link in a stored procedure : table or view does not exist
MySQL: Limiting number of results received based on a column value | Combining queries
sql select records having count > 1 where at lease one record has value

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!