Postgres Pro
Downloads
Home   >   mailing lists

Re: is there a function in postgresql that can be used for retrieving deleted rows - Mailing list pgsql-general

From David Johnston
Subject Re: is there a function in postgresql that can be used for retrieving deleted rows
Date
Msg-id FB3ACCC4-64E4-4F9B-A0F8-09F699B01963@yahoo.com
Whole thread Raw
In response to is there a function in postgresql that can be used for retrieving deleted rows  ("Charles Waweru" <cwaweru@systempartners.biz>)
List pgsql-general
Tree view
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: 9.0: plpgsql eror when restoring a database as a non superuser
Next
From: Steve Atkins
Date:
Subject: Re: is there a function in postgresql that can be used for retrieving deleted rows