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

Поиск
Список
Период
Сортировка
От raghu ram
Тема Re: Is there a way to recover deleted records if database has not been vacuumed?
Дата
Msg-id CALnrrJRT+Ao_qQyj_YZWGAEkQfSSg=-HNNB+ANLj_DLy4BHinQ@mail.gmail.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 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



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

Предыдущее
От: Frank Church
Дата:
Сообщение: Is there a way to recover deleted records if database has not been vacuumed?
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: is there any query so that I may find the list of columns those have rules?