Thread: Is there a way to recover deleted records if database has not been vacuumed?
Is there a way to recover deleted records if database has not been vacuumed?
From
Frank Church
Date:
I am using Django to develop an app and I think I must have done a syncdb (which deletes all records) without realizing it.
I have not vacuumed that database and I have also made a copy of the data directory.
Is there some way to recover the deleted records?
--
Frank Church
=======================
http://devblog.brahmancreations.com
Re: Is there a way to recover deleted records if database has not been vacuumed?
From
raghu ram
Date:
On Mon, Jul 2, 2012 at 3:21 PM, Frank Church <vfclists@gmail.com> wrote:
I am using Django to develop an app and I think I must have done a syncdb (which deletes all records) without realizing it.
I have not vacuumed that database and I have also made a copy of the data directory.
Is there some way to recover the deleted records?
You can perform Point in time recovery to recover the deleted records,if you have enabled database in WAL archiving mode.
Below URL provides more information of the Point-in-time recovery on PostgreSQL
Thanks & Regards,
Raghu Ram
Re: Is there a way to recover deleted records if database has not been vacuumed?
From
hubert depesz lubaczewski
Date:
On Mon, Jul 02, 2012 at 10:51:33AM +0100, Frank Church wrote: > I am using Django to develop an app and I think I must have done a syncdb > (which deletes all records) without realizing it. > I have not vacuumed that database and I have also made a copy of the data > directory. > Is there some way to recover the deleted records? check this - maybe it can help: http://www.depesz.com/2012/04/04/lets-talk-dirty/ Best regards, depesz -- The best thing about modern society is how easy it is to avoid contact with it. http://depesz.com/