[GENERAL] Is there a way to recover deleted records if database has not been vacuumed?
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: [GENERAL] Is there a way to recover deleted records if database has not been vacuumed?
On Mon, Jul 2, 2012 at 3:21 PM, 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? > > 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 http://www.mkyong.com/database/postgresql-point-in-time-recovery-incremental-backup/ Thanks & Regards, Raghu Ram
Re: [GENERAL] Is there a way to recover deleted records if database has not been vacuumed?
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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general