Re: Is there a way to recover deleted records if database has not been vacuumed?

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: Is there a way to recover deleted records if database has not been vacuumed?
Дата
Msg-id 20120702142144.GA9427@depesz.com
обсуждение исходный текст
Ответ на Is there a way to recover deleted records if database has not been vacuumed?  (Frank Church <vfclists@gmail.com>)
Список pgsql-general
Дерево обсуждения 
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/

В списке pgsql-general по дате отправления:

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: is there any query so that I may find the list of columns those have rules?
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Postgresql 9.0.6 alway run VACUUM ANALYZE pg_catalog.pg_attribute