Re: is there a function in postgresql that can be used for retrieving deleted rows

Поиск
Список
Период
Сортировка
От David Johnston
Тема Re: is there a function in postgresql that can be used for retrieving deleted rows
Дата
Msg-id FB3ACCC4-64E4-4F9B-A0F8-09F699B01963@yahoo.com
обсуждение исходный текст
Ответ на is there a function in postgresql that can be used for retrieving deleted rows  ("Charles Waweru" <cwaweru@systempartners.biz>)
Список pgsql-general
Дерево обсуждения
On Oct 22, 2011, at 1:23, "Charles Waweru" <cwaweru@systempartners.biz> wrote:

I am looking for a tool in the PostgreSQL database that can help to audit fraudulent activities on a PostgreSQL database. Of particular interest is how to retrieve say from a PostgreSQL sales database all the deleted rows.

 

Any suggestion please would be appreciated.

 

Charles


You have to manually save the row to an archive table prior to deleting it.  Once you have deleted a row from a table you cannot get it back.

There are multiple options to choose from to implement such an archive process.

David J.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: 9.0: plpgsql eror when restoring a database as a non superuser
Следующее
От: Steve Atkins
Дата:
Сообщение: Re: is there a function in postgresql that can be used for retrieving deleted rows