By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,516 Members | 1,369 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,516 IT Pros & Developers. It's quick & easy.

get back deleted data from a table in postgres

P: 20
Hi,

I made a blunder mistake..i have deleted some 100 rows from my table in postgres and that is very important in my project..pls give me a solution how to recover those deleted data ..i dont have any dump of that table....

thanks in advance
Feb 26 '08 #1
Share this Question
Share on Google+
7 Replies


Expert 100+
P: 700
Hi,

I made a blunder mistake..i have deleted some 100 rows from my table in postgres and that is very important in my project..pls give me a solution how to recover those deleted data ..i dont have any dump of that table....

thanks in advance
do you have WAL files?
Feb 26 '08 #2

P: 20
do you have WAL files?


No rski,

i never heard abt that..i am a new bie..
so pls help me and what is the WAL files?
Feb 26 '08 #3

P: 20
No rski,

i never heard abt that..i am a new bie..
so pls help me and what is the WAL files?
i have already google many hours and wasted my time
i have tried with toast data as suggested by some sites
Feb 26 '08 #4

debasisdas
Expert 5K+
P: 8,127
If the transactions are commited , i don't think you can recover all those records back.
Feb 26 '08 #5

P: 20
If the transactions are commited , i don't think you can recover all those records back.


NO,i have not committed the transaction
Feb 26 '08 #6

Expert 100+
P: 700
NO,i have not committed the transaction
if you're begginer you probably do not understand what mnsprasad says because
the question is if you start the transaction using 'begin transaction' command before deleting rows and and do not confirm that transaction. I'm afraid you do not, you just delete rows (using delete command) if so it means that the transaction have been confirmed.
When you delete rows they phisically still exists in a table until you call the 'vacuum' command, but i don't know if there is a way do restore that rows, i do not know a software which do that (postgres do not).
WAL is a way to do a incremental buckups, using it you can restore a database. More on postgresql.org.
Feb 26 '08 #7

P: 20
if you're begginer you probably do not understand what mnsprasad says because
the question is if you start the transaction using 'begin transaction' command before deleting rows and and do not confirm that transaction. I'm afraid you do not, you just delete rows (using delete command) if so it means that the transaction have been confirmed.
When you delete rows they phisically still exists in a table until you call the 'vacuum' command, but i don't know if there is a way do restore that rows, i do not know a software which do that (postgres do not).
WAL is a way to do a incremental buckups, using it you can restore a database. More on postgresql.org.

Thank u..rski
I have just deleted a table ...if anyone knows how to recover deleted data pls reply me
Feb 27 '08 #8

Post your reply

Sign in to post your reply or Sign up for a free account.