recover deleted tuples

From: "Rune Lending" <rune(at)inpoc(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: recover deleted tuples
Date: 2004-07-14 16:20:32
Message-ID: 001d01c469be$7cadbc80$0d5aa8c0@urlemainframe
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We had an accident with a table where all tuples where deleted. We have not run VACUUM yet and it seems like the datas are in place in the base directory. Our backup were not active when this happened.
I have seen some talk about that it is possible to restore those missing data in this case, but I have not yet seen a solution for it. Can anyone please help with this problem, it is kind of critical for us..

Thanks a lot in advance..

/rune

Browse pgsql-admin by date

  From Date Subject
Next Message Jodi Kanter 2004-07-14 16:34:53 adding defaults
Previous Message markw 2004-07-14 15:55:52 Re: [HACKERS] Point in Time Recovery