get back deleted data from a table in postgres

Originally Posted by mndprasad

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

Originally Posted by rski

do you have WAL files?

Originally Posted by mndprasad

No rski,

i never heard abt that..i am a new bie..
so pls help me and what is the WAL files?

Originally Posted by debasisdas

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

Originally Posted by mndprasad

NO,i have not committed the transaction

Originally Posted by rski

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.